Õâ¸öSQLÓï¾äÕâôд

SQL±íÒ»
ÐòÁкÅ,    ²úÆ·      bz

0001        mc      0

0002        mc      0

0003        mc1    0

SQL±í¶þ
ÐòÁкÅ,    ²úÆ·      bz


excl ±í
ÐòÁкÅ,    ²úÆ·
0001      mc
0003      mc1 
0022      mc1


ÏÖÔÚÐèÒª±È¶Ô2±í(ÒÔÐòÁкźͲúÆ·±È¶Ô,¶Ô±È¶Ô³É¹¦µÄÈÃBZ¸ÄΪ1,²»¶ÔµÄдÈëSQL±í2)
 

 

---

ÐèÒª±È¶ÔµÄÊÇ,SQL±íÒ»
ºÍexcl ±í

---

excl±íÊÇEXCLÎļþÓ´,±È¶Ô³É¹¦µÄÒ²ÒªÌåÏÖÓ´

---

SQL code:
if object_id('[t1]') is not null drop table [t1]
go
create table [t1]([ÐòÁкÅ] varchar(4),[²úÆ·] varchar(3),[bz] int)
insert [t1]
select '0001','mc',0 union all
select '0002','mc',0 union all
select '0003','mc1',0
go
select * into t2 from t1 where 1=2;
go
if object_id('[excl]') is not null drop table [excl]
go
create table [excl]([ÐòÁкÅ] varchar(4),[²úÆ·] varchar(3))
insert [excl]
select '0001','mc' union all
select '0003','mc1' union all
select '0022','mc1'

-->¸üÐÂ
update t1
set bz=1
where exists(select 1 from excl where t1.[ÐòÁкÅ]=excl.[ÐòÁкÅ]