比如说数据库中有name这个字段,但是有的记录中name为空,那么我要查询所有name为空的数据怎么查询?
7 个解决方案
#1
name is null
#2
where isnull(name,'')=''
#3
select * from tablename where name is null
#4
SELECT * FROM TableName WHERE Name = '' OR Name IS NULL
#5
where name is null or name=''
这个问题也能上这儿哟
这个问题也能上这儿哟
#6
name is null
#7
谢谢拉,^_^
#1
name is null
#2
where isnull(name,'')=''
#3
select * from tablename where name is null
#4
SELECT * FROM TableName WHERE Name = '' OR Name IS NULL
#5
where name is null or name=''
这个问题也能上这儿哟
这个问题也能上这儿哟
#6
name is null
#7
谢谢拉,^_^