Post reply

How to select a column named 'Key'?

  • July 15, 2009 at 7:25 am

    #208189

    Hi All - I'm sure this is a silly question covered under SQL 101, but I am not clear how to work with a table that has a column named 'Key'. Everytime I do something like "select key from table" I get an error "Incorrect syntax near the keyword 'key'" and 'key' has blue syntax formatting. I am sure there is a way I can do work with the column, but I don't know how. Any help would be much appreciated.

  • July 15, 2009 at 7:33 am

    #1025022

    Try this

    CEWII

  • July 15, 2009 at 7:48 am

    #1025042

    SELECT FROM SomeTable

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 15, 2009 at 8:06 am

    #1025061

    Boy am I silly. That is one of the few bits of SQL I actually know (or should know). Thank you both very much - I really appreciate the guidance.

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

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