create procedure [spname]([spvariable])
as
begin
begin transaction
begin try
–具体sql过程
commit;
end try
begin catch
rollback;
end catch
end
create procedure [spname]([spvariable])
as
begin
begin transaction
begin try
–具体sql过程
commit;
end try
begin catch
rollback;
end catch
end
该资源仅限VIP专享下载