• I try this out with @bit = 0 it gives message "no"

    if @bit = -500 ,it gives message "yes",

    if @bit = -1 then also it gives "yes".

    The Explanation Given for Answer : Bit constants are represented by the numbers 0 or 1, if a number larger than one is used, it is converted to one.

    but what about the values less than 1, still they consider as 1

    Please explain me more about the negative values used for bit datataype.