این را امتحان کنید :
alter Proc [dbo].[Select_Path_New]
@Table_Name nvarchar(50),
@Name nvarchar(200)
AS
DECLARE @Sql_Code nvarchar(300)
SET @Sql_Code = N'SELECT * FROM [' + @Table_Name + '] WHERE Name = ' + @Name
EXEC(@Sql_Code)
این را امتحان کنید :
alter Proc [dbo].[Select_Path_New]
@Table_Name nvarchar(50),
@Name nvarchar(200)
AS
DECLARE @Sql_Code nvarchar(300)
SET @Sql_Code = N'SELECT * FROM [' + @Table_Name + '] WHERE Name = ' + @Name
EXEC(@Sql_Code)