Hi All,

I would like to create a store procedure in SQL with input parameter is table's name so that i just change name of table when execute select statement.

Ex : Create Procedure TestTable @sTable varchar(25)
as
Begin
select * from @sTable
End

But this syntax is not correct, Any advise?

Thanks so much,

Thanh Nguyen