• Easy question for the day!

    I agree with the explanation by "demonfox", here is the BOL link for BIT datatype:

    http://msdn.microsoft.com/en-us/library/ms177603.aspx

    It clearly says "any non-zero value will be converted to 1". I could not find the concept of the number being converted into binary and than getting truncated. Can anyone pour some light on what is happening internally?

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter