• The Result depends on set option

    SET ANSI_NULLS OFF

    select * from ##TableNulls where col2 <> null -- This will give Result

    SET ANSI_NULLS ON

    select * from ##TableNulls where col2 <> null -- this will not give result