--ntext字段为空的
--ntext字段为空的
select * from [yuqing].[dbo].[CaiJi] where isnull(datalength(content),0) =0
--删除为空的
delete [yuqing].[dbo].[CaiJi] where [yuqing].[dbo].[CaiJi].[Title] in(
select [Title] from [yuqing].[dbo].[CaiJi] where isnull(datalength(content),0) =0)

浙公网安备 33010602011771号