syntax problem with select command

[Mich]

Hi,

the table 'l0382_project1' exists in sql server. I can see it.
Now in asp.net, i want to check whether it exists but i get "invalid column
name":

1st attempt:
comd.CommandText = "SELECT COUNT(*) FROM sys.tables WHERE [name] =
[l0382_project1]"
connection.Open()
nr = comd.ExecuteScalar()

Invalid column name 'l0382_project1'.


2nd attempt:
comd.CommandText = "SELECT COUNT(*) FROM sys.tables WHERE [name] =
['l0382_project1']"
connection.Open()
nr = comd.ExecuteScalar()

Invalid column name 'l0382_project1'.


Could somebody tell me the right syntax, please?
Thanks
Mich

 

[Pawel Potasinski]

comd.CommandText = "SELECT COUNT(*) FROM sys.tables WHERE [name] =
N'l0382_project1'"

 

[Tibor Karaszi]

The name of the table in the context of your query is just a regular string, so the query should be:

WHERE [name] = 'l0382_project1'

 

[Mich]

Thanks for replying. It works now.

The name of the table in the context of your query is just a regular
string, so the query should be:

WHERE [name] = 'l0382_project1'


--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

Hi,

the table 'l0382_project1' exists in sql server. I can see it.
Now in asp.net, i want to check whether it exists but i get "invalid
column name":

1st attempt:
comd.CommandText = "SELECT COUNT(*) FROM sys.tables WHERE [name] =
[l0382_project1]"
connection.Open()
nr = comd.ExecuteScalar()

Invalid column name 'l0382_project1'.


2nd attempt:
comd.CommandText = "SELECT COUNT(*) FROM sys.tables WHERE [name] =
['l0382_project1']"
connection.Open()
nr = comd.ExecuteScalar()

Invalid column name 'l0382_project1'.


Could somebody tell me the right syntax, please?
Thanks
Mich