Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Can I have an input paramater in a stored procedure be a table name?
Well guys i answered my own question: The trick is to put the whole thing into one statement. if anyone knows a better way, please post it ;) declare @xxx varchar (5000) declare @pTableName varchar (10) declare @pNew varchar(6) declare @pOld varchar(6) declare @ID1 as varchar (6) set @ID1 =...- Cardshark
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Can I have an input paramater in a stored procedure be a table name?
Can I have an input paramater in a stored procedure be a table name? If so, how do I use the paramater in the 'FOR' clause to set a cursor. Example: DECLARE curs CURSOR FOR SELECT @pTableName WHERE ... and so fourth?- Cardshark
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
