22,209
社区成员
发帖
与我相关
我的任务
分享
create procedure pr_test (
@Name varchar(8),
@Age tinyint,
@class varchar(8)
)
as
begin
begin tran
begin try
update A set Name = @Name where ...
update B set Age = @Age where ...
update C set class = @class where ...
commit tran
end try
begin catch
rollback tran
end catch
end