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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How do I use EXISTS with a Dynamic Table Name in a STORED PROCEDURE
If my stored procedure takes in a table name, how do I verify that that table exists? I have tried everything under the sun, like this: incoming variable is called @TABLENAME='BLAH' if exists (@TABLENAME) --Gives an error if exists (Select * from @TABLENAME) --gives an error if exists...- aaqqwwss
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
