"State" is a keyword

  • Seriously?

    Does Microsoft not have a clue how many people actually use the word "State" for table and column names? I mean, MS is based in the U.S. How could they not have realized that some people don't want to be using keywords in table names and column names? And now they've practically forced this upon us?

    Could they not have named this keyword a little differently?

    [/rant]

    On a slightly less annoyed note, I can't even find it in BOL aside from "State Property", "State Enumeration", and "State Element". Does anyone know what this new keyword references or what other T-SQL construction this keyword is a part of?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • This was removed by the editor as SPAM

  • stewartc-708166 (7/27/2011)


    I found it in Reserved Keywords (Transact-SQL), Future Keywords section.

    holly crap.. there's even more future keywords than the current ones :w00t:.

  • Thanks for the link. It explains why I can't figure out what State is being used for. So far, it's not.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • It's reserved to follow ANSI SQL-99 standard as a keyword.

    -------------------------------------------------
    Will C,
    MCITP 2008 Database Admin, Developer

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply