delete from tb where col is null and col1 is null and ....
关键是我不知道有字段名称,这个表是从excel导入的
declare @sql varchar(8000) select @sql=isnull(@sql+' and ','')+name +' is null' from sys.columns where object_id=object_id('表') set @sql='delete 表 where '+@sql exec(@sql)
declare @sql varchar(8000) select @sql=isnull(@sql+' and ','')+name +' is null' from sys.columns where ID=object_id('表') set @sql='delete 表 where '+@sql exec(@sql) 大大的要修改下
select @sql=isnull(@sql+' and ','')+name +' is null'
from sys.columns where object_id=object_id('表')
set @sql='delete 表 where '+@sql
exec(@sql)
select @sql=isnull(@sql+' and ','')+name +' is null'
from sys.columns where ID=object_id('表')
set @sql='delete 表 where '+@sql
exec(@sql) 大大的要修改下