Sponsored by Gluten Free Waffles and Sliced Bananas

Monday, March 29, 2010

Using Reserved Keywords in SQL Server (T-SQL)

2:02 PM Posted by Tyson Nero 1 comment
It's a very basic concept, but for the new database developer, it can cause fits. One T-SQL reserved keyword is "description" which is commonly used as a column name for instance. You probably should not get in the habit of using reserved keywords as column names and such, but if you do, the proper way to express them is by enclosing the name in brackets as so: [description].

SELECT [description] from Table1

1 comment:

  1. Hey Now Code Monkeez,

    Good to know. T-SQL's always fun!

    Thx 4 the info,
    Catto

    ReplyDelete