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

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

When dealing with a relational database management system (RDBMS) like SQL Server, compatibility level is an important concept to understand....
In this blog post, let’s learn about the error message “49975 – Unable to load controller client certificate due to...
In this blog post, let’s learn about the error message “49973 – Cannot remove tempdb remote file to local tempdb...