Dealing with the column names that looks like SQL Keywords in SQL Server

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

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

You cannot copy content of this page