Post reply

where clause..Please help

  • February 9, 2005 at 5:48 am

    #65645

    when i issue this statement;

     select * from table_name where column = 'abc'  it works

    select * from table_name where column = "abc" it doesn't

    Is double quotes not allowed in MS SQL.

    I am trying this in Query analyser. version 8.

     

    Any input would be much appreciated.

    S Rao

     

     

  • February 9, 2005 at 6:37 am

    #541343

    Hi,

    If you go to Tools->Options->Connection Properties you can uncheck "Set quoted_identifier" which will allow you to use double quotes.

    Unfortunately this is really bad practice and will cause you all sorts of problems longer term - better off just getting used to only using single quotes.......

    Have fun

    Steve

    We need men who can dream of things that never were.

  • February 10, 2005 at 6:56 am

    #541559

    You can set it dynamically in T-SQL :

    SET QUOTED_IDENTIFIER ON/OFF

    Why do you say that it is bad practice? - or do you just mean at the connection level?

  • February 14, 2005 at 10:24 am

    #542121

    many thanks for your help.

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

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