كيف أدخل مجهول اسم جدول الى Stored Procedure

Use sp_executesql .call this procedure from your code to evaluate the sql query

CREATE PROCEDURE test

@tablename char(10)

as
DECLARE @query NVARCHAR(500)
Set @query = N'Select*From ' + @tablename
EXEC sp_executesql @query
GO

executing :

test "Students" is equal to "Select*From Students"

شكراً جزيلاً أخ مدني و ماقصرت