SQL SERVER – 2005 Reserved Keywords

Microsoft SQL Server 2005 uses reserved keywords for defining, manipulating, and accessing databases. Reserved keywords are part of the grammar of the Transact-SQL language that is used by SQL Server to parse and understand Transact-SQL statements and batches. It is not legal to include the reserved keywords in a Transact-SQL statement in any location except that defined by SQL Server. No objects in the database should be given a name that matches a reserved keyword. Although it is syntactically possible to use SQL Server reserved keywords as identifiers and object names in Transact-SQL scripts, you can do this only by using delimited identifiers.

Please use Microsoft MSDN BOL to see all the Reserved Keywords. The text above has been referenced from MSDN BOL.

Reference : Pinal Dave (https://blog.sqlauthority.com)

Previous Post
SQL SERVER – Search Text Field – CHARINDEX vs PATINDEX
Next Post
SQL SERVER – SP Performance Improvement without changing T-SQL

Related Posts

No results found.

3 Comments. Leave new

  • A table has thee columns and one row.
    I want the output as 5 times repetation of the data.

    Reply
  • Hi,
    I want to retrieve “Reserved keywords” of SQL SERVER 2005 using QUERY.
    can you tell me is it possiable to retrieve Reserved Keywords using query.

    Thanks in advance
    Girish

    Reply
  • Thanks Dave,
    But how can we replace such words which break SQL Statement. Can we check using any procedure/function in database before EXEC any Sql Statement.

    Thanks,
    Shyam

    Reply

Leave a Reply

Menu
Exit mobile version