批量更新数据（batches update ）插入数据（batches insert）

CREATE TABLE #A(CDDECIMAL,SysCDINT,FLAGTINYINT)insert into #Avalues(1001,5,1)---------------------------CREATE TABLE #B(CDDECIMAL,SysCDINT,FLAGTINYINT)insert into #Bvalues(1001,5,0)-----------------------------SELECT * FROM #ASELECT * FROM #B--------------------------UPDATE aSET a.FLAG = b.FLAGFROM#Aajoin#Bbona.CD =b.CDANDa.SysCD =b.SysCD---------------------------DROP TABLE #ADROP TABLE #B

 

select 1 as a into #aselect 102 as a into #bselect a.a a,b.a binto #dfrom#a afull join#b bon1=1select 1 as a, 101 as binto #cinsert into #c values(1,102)select * from #cselect * from #dinsert into #cselect *from#dwherenot exists(select afrom #cwhere#d.a=#c.aand#d.b=#c.b)drop table #adrop table #bdrop table #cdrop table #d