select count(id) from student where ISNULL(pwd,'')='' 这样 无论pwd=''或者pwd为null都可以查到
查询非空字段,只需:ISNULL(pwd,'')!=''
select count(id) from student where ISNULL(pwd,'')='' 这样 无论pwd=''或者pwd为null都可以查到
查询非空字段,只需:ISNULL(pwd,'')!=''
转载于:https://www.cnblogs.com/zhangqs008/archive/2010/09/06/2341176.html