HomeSQL ServerDealing with the column names that looks like SQL Keywords in SQL Server

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

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