I am working on a table and using select query to select some data. I am abe to execute but i used double quotes for Account Name and Plan number column. But when I remove the double quotes i am getting below error message. Please find the attached file for all information.
Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'Plan'.
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'Plan'.
I checked your question, but there is no attachment however i understand your question.
You can use below syntax for for your requirement-
Select * from [Table_Name]
Where [Column_Name] = 'Text'Devbrat Tripathi 10 Jun 2016 1 0