Select Query

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'.


  Rupesh Kumar


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     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any