select * from [table name] Where [column name]=null
—————-you will not get any outputĀ because Ansi null is on
so try this :
set ANSI_NULLS Off
select * from [table name] Where [column name]=null
–Now you’ll get all Null Values.
select * from [table name] Where [column name]=null
—————-you will not get any outputĀ because Ansi null is on
so try this :
set ANSI_NULLS Off
select * from [table name] Where [column name]=null
–Now you’ll get all Null Values.