select * from 表名 where not exists(select 1 from 表名 where charindex('哈哈',标题)>0)
delete from 表名 where not exists(select 1 from 表名 where charindex('哈哈',标题)>0)
DELETE FROM Spzs WHERE (NOT EXISTS (SELECT *1 FROM spzs WHERE charindex('挖掘机', cmpc) > 0))我的字段名是 cmpc 怎么说我列名无效啊
-------你先查询一下看看出不出问题 SELECT * FROM spzs WHERE charindex('挖掘机', cmpc) > 0--你的写的不对啊~~~ DELETE FROM Spzs WHERE NOT EXISTS (SELECT 1 FROM spzs WHERE charindex('挖掘机', cmpc) > 0)
where not exists(select 1 from 表名 where charindex('哈哈',标题)>0)
where not exists(select 1 from 表名 where charindex('哈哈',标题)>0)
(NOT EXISTS (SELECT *1 FROM spzs WHERE charindex('挖掘机', cmpc) > 0))我的字段名是 cmpc 怎么说我列名无效啊
SELECT * FROM spzs WHERE charindex('挖掘机', cmpc) > 0--你的写的不对啊~~~
DELETE FROM Spzs WHERE NOT EXISTS (SELECT 1 FROM spzs WHERE charindex('挖掘机', cmpc) > 0)