更新 表部门dept(id,Name,state) 表员工emp(id,deptid,name) 更新部门表的state=0 条件是部门的id=d1001且该部门没有员工。 用一条sql语句 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 update deptset dept.state=0 from dept dwhere dept.id='d1001' and not exists(select * from emp where deptid=dept.id) update d set state=0 from dept d where d.id=d1001 and not exists(select 1 from emp where deptid=d.id) update dept set state=0 where id=d1001 and id not in(select deptid from emp where deptid is not null and deptid !='') /*表部门dept(id,Name,state) 表员工emp(id,deptid,name) */update set state=0 where id in(select id from emp where deptid='d1001' and name is null) 支持update dept set dept.state=0 from dept dwhere dept.id='d1001' and not exists(select * from emp where deptid=dept.id) update aset state = 0from dept a where not exists(select 1 from emp where a.id = id)adn a.id = 'd1001' update dept set state='0' from dept left join emp on dept.id=emp.deptid and emp.id is null 更正下update dept set state='0' from dept left join emp on dept.id=emp.deptid where emp.id is null and dept.id=d1001 update dept set state = 0 from dept t where id = 'd1001' and not exists (select 1 from emp where deptid = t.deptid) 简单的更新问题 SQL中怎样获得动态生成表中的字段的名称 服务器上有多个数据库,如何控制某一个用户只能访问某一个数据库 存储过程语句-帮我具体解释这段小代码 一个SQL文问题,请高手帮帮忙,谢谢了 请教一条sql语句 在当前行中找到的列过多在上次定义的列的数据之后找到了非空白字符 数据库查询的问题?挺深奥的会的帮个忙! 用程序如何得到正在阻塞进程的ID? 存储过程分页有问题,急救 哪不对??? 两张表关联查询问题 高手帮忙!!! 求一sql
set dept.state=0
from dept d
where dept.id='d1001'
and not exists(select * from emp where deptid=dept.id)
表部门dept(id,Name,state)
表员工emp(id,deptid,name)
*/
update set state=0 where id in
(select id from emp where deptid='d1001' and name is null)
where dept.id='d1001' and not exists(select * from emp where deptid=dept.id)
update a
set state = 0
from dept a where not exists(select 1 from emp where a.id = id)
adn a.id = 'd1001'
update dept set state='0' from dept left join emp on dept.id=emp.deptid and emp.id is null
update dept set state = 0 from dept t where id = 'd1001' and not exists (select 1 from emp where deptid = t.deptid)