Hi, this could be very stupid for almost all of you but actually not for me, as I am still a beginner with Transact.
I want to write a stored procedure with several parameters. One of this parameters will be the name of a db's table. I can't manage doing it!
My code would be something like:
declare @tabxxx sysname
set @tabxxx = TABLE_NAMExxx
select * from @tabxxx
what is wrong with it?
best regards
I want to write a stored procedure with several parameters. One of this parameters will be the name of a db's table. I can't manage doing it!
My code would be something like:
declare @tabxxx sysname
set @tabxxx = TABLE_NAMExxx
select * from @tabxxx
what is wrong with it?
best regards