این را امتحان کنید :

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)