if exists (select 1 from #tmp_dj_xsg212 WHERE shangplx LIKE

来源：学生作业帮编辑：作业帮分类：综合作业时间：2024/05/16 19:48:25

if exists (select 1 from #tmp_dj_xsg212 WHERE shangplx LIKE '%冷%'

从里往外看
select 1 from #tmp_dj_xsg212 WHERE shangplx LIKE '%冷%'
从tmp_dj_xsg212 这个表查询所有shangplx 字段的值包含“冷”这个字的
if exists ,可以理解为上面的查询结果如果有内容的话,就执行后面的语句.

if exists (select 1 from #tmp_dj_xsg212 WHERE shangplx LIKE if not exists (SELECT * From TA_ARTIFICER Where ARTID = @Art if not exists(select 1 from sysobjects where type='U' and na // IF EXISTS (SELECT name FROM m select *from A where A.a like '%1%'||'%' select * from book where 1=1 select * from student where name like '%[^ja,as,on]%' SQL语句理解 select * from B where (select count(1) as num from A sql 中关于 like SELECT * FROM Persons WHERE City LIKE '%g' insert into REC_OVER(ORG_ID) select '1' from dual where not 数据库相关子查询 SELECT SNFROM SWHERE (NOT EXISTS( SELECT *FROM CWH select * from teacher where s_id in(select s_id from student