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