Subscribe to our YouTube Channel for more Videos

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

Senthil Kumar B
Senthil Kumar is a former Microsoft MVP (Most Valuable Professional). He is a Co-Author of the book "Windows 10 Development Recipes using JavaScript and CSS" for Apress Publication. He is a technical presenter, blogger, mentor and a Geek.  Senthil is a regular speaker is various local user groups. He has presented at conferences like Great Indian Developer Summit (GIDS) & Microsoft DevCamps. You can reach out to him via his Twitter handle @isenthil.