Declare @Myparam as Varchar(50), @SqlStr varchar (512) Set @MyParam = 'TableName' SET @SqlStr = 'Select * from A_Table as T1 Left join ' + ; @MyParam + ' as T2 on T2.Id=T1.Id' EXECUTE (@SqlStr)>How can I pass a table name as a parameter in SQL Server 2000 stored procedure?
>Declare @Myparam as Varchar(50) > >Set @MyParam = 'TableName' > >Select * from A_Table as T1 >Left join @MyParam as T2 on T2.Id=T1.Id >>