Transaction processing of SQL Server database

SQL Server There are two main ways to write the transaction processing of database ：

The first one is ：

begin transaction  -- Open transaction

DECLARE @i INT;   -- Define a variable i
set @i=0; -- Give the variable an initial value

insert into TB_Salesman values ('SM007',' Li ling ',' Woman ','D003',' Level seven ');
set @[email protected][email protected]@ERROR

insert into TB_Salesman values ('SM006',' Li ling ',' Woman ','D003',' Level seven ');
set @[email protected][email protected]@ERROR

if(@i>0)

begin
rollback tran;-- Transaction rollback
print ' operation failed '
end

else

begin
commit tran;-- Transaction submission
print ' Successful operation '
end

GO

The second kind ： Use try  catch

begin transaction -- Open transaction

DECLARE @i INT;   -- Define a variable i
set @i=0;        -- Give the variable an initial value

begin try
insert into TB_Salesman values ('SM008',' Li ling ',' Woman ','D003',' Level seven ');
insert into TB_Salesman values ('SM009',' Li ling ',' Woman ','D003',' Level seven ');
end try

begin catch
 set @[email protected]+1; -- It can be executed normally with or without a plus sign
end catch

if(@i>0)

begin
rollback tran;  -- Transaction rollback
print ' In the wrong ';
end

else

begin
commit tran;  -- Transaction submission
print 'OK';
end

GO