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