why null not equal to 1 is not return true?
declare @somebit bit if(@somebit <> 1) begin select 123 end in the above code it is not returning the 123, that @somebit <> 1 return false in SQL. can anyone explain why? i have Tried This in my code, it is returing false , instead of true. sql sql-server sql-server-2012 null ssms