May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – 2005 Reserved Keywords

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
3 Comments

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

  • rama
    January 5, 2008 3:13 am

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

    Reply
  • Girish
    March 19, 2008 3:54 pm

    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
  • Shyam
    July 24, 2008 10:33 am

    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

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 90 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Comprehensive Database Performance Health Check

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

SQL Server Performance Tuning Practical Workshop

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.