--使用事务来进行更新,进而避免一条更新到了,另一条没更新到
CREATE PROCEDURE update_pflg
@orderno varchar(18),@areano varchar(10) ,@autoid varchar(10),@userno varchar(20),@cwno varchar(50),
@Eout1 int output
AS
BEGIN
begin try
begin tran
update b set b.pflg=3 from sa_orderlist b
where b.orderno=@orderno and b.areano=@areano and b.printpc=@autoid
update a set a.cwno=@cwno,mkerid=@userno,mkerdate=getdate(),areano=@areano,printpc=@autoid from st_gostrlist a
where a.orderno=@orderno and a.cwno='Z999' and a.areano=@areano and a.printpc=@autoid
select @Eout1 = 1 --成功
commit
end try
begin catch
rollback
select @Eout1 = 2 --失败
end catch
END
使用事务来进行更新
最新推荐文章于 2024-05-12 22:43:42 发布