There are times when you might have a column names in your SQL Server database table that might looks like the keywords in SQL. When you try to access them directly , you might get an error when executing the query directly.
How to deal with the Column names similar to the keywords in SQL Server ?
In order to overcome this issue , you need to wrap the column name in square brackets.
Assume that the column name is called “description” in the table employee , you would do the following to get the description field from the table.
SELECT [description] from Employee