Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Why this Query Give Error

Author  Topic 

salman
Starting Member

5 Posts

Posted - 2004-08-12 : 18:16:27
table_name=request.querystring("table_name")

sql = "select * from '" & table_name & "'"


why the above query has syntax error

salman

mr_mist
Grunnio

1870 Posts

Posted - 2004-08-13 : 03:06:09
You don't need the single quotes around the table name.

-------
Moo. :)
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2004-08-13 : 16:40:21
(Moved the the T-SQL forum.)

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page
   

- Advertisement -