select * from info where typeid= 1 and xxx is NOT null select * from info where typeid= 1 and xxx is null
sql server 查询数据判断为空
原文:http://www.cnblogs.com/enych/p/7902754.html