Hi All,
How can we pass a tablename as parameter to Stored Procedure. For example If I want to create an SP in the following way:
CREATE PROCEDURE myproc
@cTablename varchar(40)
AS
SELECT * FROM @cTableName
the above code does not work. Is any other way to do the same.
Pl. help me out
Thanks
Raoshan