locked
What is STATE Keyword? - Any Explanation RRS feed

  • Question

  • Hi,

    I see STATE is a future keyword in sql server.

    Is there any explanation with example: What it actually refers to?

    Monday, March 25, 2013 5:42 AM

Answers

  • It is a word they have reserved for possible future use.  You will find no explaination.  It has been reserved and unused since at least SQL 2000 - maybe longer 

    Chuck Pedretti | Magenic – North Region | magenic.com


    Monday, March 25, 2013 3:26 PM

All replies

  • STATE is on the list of reserved keywords found here:

    http://msdn.microsoft.com/en-us/library/ms189822.aspx

    This does not imply that the word will be used in the future as part of T-SQL grammar, only that it has been reserved due to various SQL related standards (ISO/ANSI, etc).  You can still use this list by surrounding them with delimiters.

    Thanks,
    Sam Lester (MSFT)



    My Blog

    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

    • Proposed as answer by Iam_Rakesh Monday, March 25, 2013 6:20 AM
    • Unproposed as answer by srinivas kadiyala Tuesday, April 2, 2013 2:15 PM
    Monday, March 25, 2013 6:04 AM
  • See
    http://msdn.microsoft.com/en-us/library/ms180031.aspx
    http://msdn.microsoft.com/en-us/library/ms189797.aspx

    Many Thanks & Best Regards, Hua Min

    Monday, March 25, 2013 6:32 AM
  • Hi HuaMin Chen,

    Thanks for reply.

    I didnt asked for ERROR_STATE or XACT_STATE.

    I go to know: there is a future reserved word: STATE.
    Is there any explanation for that?

    Monday, March 25, 2013 3:16 PM
  • Thanks Samuel Lester,

    Yes I understood that it is reserved due to SQL standards,

    But i was asking like other keywords : Is there any explanation of this Keyword or example?

    Monday, March 25, 2013 3:25 PM
  • It is a word they have reserved for possible future use.  You will find no explaination.  It has been reserved and unused since at least SQL 2000 - maybe longer 

    Chuck Pedretti | Magenic – North Region | magenic.com


    Monday, March 25, 2013 3:26 PM