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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
table name parameter in stored procedure
- Thread starter afybim
- Start date
jgoodman00
Programmer
- Jan 23, 2001
- 1,510
If you mean to perform an action on a table which is passed in as a parameter then you need to generate the SQL statement dynamically.
e.g.
James Goodman MCSE, MCDBA
e.g.
Code:
DECLARE @SQL varchar(2000)
SET @SQL = "SELECT * FROM " + @TableParam
EXEC @SQLJames Goodman MCSE, MCDBA
- Status
Similar threads
- Locked
- Question