SQL之空值(Null)检索

select * from Item where ISNULL(name,'')=''
select * from Item where name is null or datalength(name)=0

无论name=''或者name为null都可以查到