select * from Item where ISNULL(name,'')='' select * from Item where name is null or datalength(name)=0
无论name=''或者name为null都可以查到
select * from Item where ISNULL(name,'')='' select * from Item where name is null or datalength(name)=0
无论name=''或者name为null都可以查到
转载于:https://www.cnblogs.com/mr-hu2009/p/11248299.html