sql server查询语句条件判断字段值是否为NULL

判断字段是否为null

select * from table where c is null   

select * from table where c is not null

判断字段是否为空

select * from table where c=''

select * from talbe where c<>''