ITeye博客

sqlserver

共 1 篇文章

在sqlserver2000中实现类似oracle的Merge into的方法

begin tran t1 declare @existflag int SELECT @existflag =rcgoobpr_flag FROM ri_rcgoobpr where ri_manageunitcode=#rvManageunitCode# and rcgoobpr_id=#rcgoobpr_id# if(@existflag is not null) begin update ri_rcgoobpr set rvrcds_id=#rvrcds_id#,bnds=#bnds#,brnm=#brnm#,infndt=#infndt#,goennmcd=#goennmcd#,l…

2008-08-03 12:15 · sqlserver