Post reply

error while comparing a bit value in sql

  • May 26, 2009 at 12:00 pm

    #131535

    Hi,

    I have declared one variable as bit, and it get set to value 1/0 by query. When I am trying to check this value as 'if @variale==1' it gives error.Any help will be appreciated.

  • May 26, 2009 at 12:28 pm

    #1000100

    Hi.

    try

    IF @variable = 1.

    (one "=")

    -----------------------
    SQL Server Database Copy Tool at Codeplex

  • May 28, 2009 at 9:41 am

    #1001520

    I tried @variable0 and it is working fine

  • May 28, 2009 at 10:11 am

    #1001547

    kavita_pansare (5/26/2009)

    When I am trying to check this value as 'if @variale==1' it gives error.

    SQL only uses one = for comparison.

    If that's not it, tell us what the error message is.

    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

  • May 29, 2009 at 7:43 am

    #1002051

    It looks like a problem I had before in a Delphi application.

    I solved it by casting to int and comparing to1 (integer value).

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

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