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

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply


x

Interesting BlogPosts to read

How to quickly remove multiple line breaks in Excel using VBA code?
There are times when you might copy few data from different source and you would end up getting unne...
How to change orientation of the worksheets in Microsoft Excel ?
This blog post will show the steps that are needed to change the orientation of the current workshee...
How to hide page breaks in worksheets in Microsoft Excel ?
When the page breaks is used to adjust the print area in a worksheet in excel , this would show up a...