transaction.sql

在学习SQL Server过程中整理的T-SQL语句

CREATE PROCEDURE TranTest
@num char,@name char(20),@add char(20)
AS

DECLARE @ErrorA int,@ErrorB int

begin transaction aa

insert into stucopy values(@num,@name)

set @ErrorA = @@error
insert into b values(@num,@Add)
set @ErrorB = @@error

if @ErrorA>0 or @ErrorB>0
begin
Rollback transaction aa
end
else
commit transaction aa
GO