meimeius
asked on
Pass tablename to stored procedure
I have a stored procedure called upsTest(see below). I’d like to pass table name as a parameter, so I create another stored procedure called uspTest1, but it doesn’t work. Is there any way I can use stored procedure to pass tablename? Thanks in advance.
CREATE PROCEDURE uspTest
AS
select * from table1
CREATE PROCEDURE uspTest1
@TableName varchar(50)
AS
select * from @TableName
CREATE PROCEDURE uspTest
AS
select * from table1
CREATE PROCEDURE uspTest1
@TableName varchar(50)
AS
select * from @TableName
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER