sql高手快来救命呀！

[small]

1、如何删除SQL数据库中的空记录？
2、用什么条件可以找到字段为空的记录？

[skyyoung]

select * from table where name is null

[windindance]

1:
delete table where name is null
2:
select * from table where name is null

[renzhm]

1.
delete from table where name is null;//若name 为 '空'在数据库中<NULL>
delete from table where name='';//若name 为 '空格'
2.
select * from table where name is null 或
select * from table where name=null

[gxdq]

select * from tablename where fieldname in (null,'',' ')

[LI_xiufu]

还需考虑空格不定的情况
select * from tablename where convert(varchar,fieldname) in (null,'')

[BlueSQu]

select * from table where trim(name) is null

[yangzi]

在sql server里 ''和null不等。所以你要分别处理。
我不知道你所说的空是前者还是后者。

[k2]

select只是抽取数据，并不能删除。

[Springer]

TO YangZi ,用ORACLE吧。
delete from TableName
where NVL(ColumnName,'') = '';

[LI_xiufu]

to k2:
已经select出来了，难道换成delete(delete from)还要教吗？