Simple SQL query fails with Invalid Column Name (MS-SQL)

Databases
InterBase (28)
MS-SQL (5)
mysql (36)
Oracle (1)

Simple SQL query fails with Invalid Column Name (MS-SQL)

This article has not been rated yet. After reading, feel free to leave comments and rate it.

Question:

I want to delete all records in my MS-SQL database that contain the city "Alexandria".
The SQL looks like this:

delete from plants where city_name = "Alexandria"

I get this error message that something does not match with a table name or alias name used in the query or that I use an Invalid Column Name 'Alexandria'.

Answer:

Many SQL parsers will allow strings to be escaped either by ' or " (single or double quote).
If you write SQL for Microsoft SQL Server, you have to use single quotes instead of double-quotes.


	// bad in Microsoft SQL delete from plants where city_name = "Alexandria" // correct delete from plants where city_name = 'Alexandria'

Comments:

Email address (not necessary): Rate as	Hide my email when showing my comment. Please notify me once a day about new comments on this topic. Please provide a valid email address if you select this option.

It seems that you are from Los Angeles, US . Info/ Feedback on this	Show city and country Show country only Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:
Add a picture: Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity. The owner of this web site reserves the right to delete such material.


	Search: