简单事务应用

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[Op_InsertProduct_Order]

AS
BEGIN
declare @error_1 int,@error_2 int,@tempIdentity int
 begin tran
 insert into OP_ProductTable (ProductName) values ('111')
 set @tempIdentity=@@identity
 set @error_1=@@error
 
 insert into OP_OrderTable (ProductID) values (@tempIdentity)
 set @error_2=@@error
 if(@error_1=0 and @error_2=0)
  begin
   commit tran
  end
 else
  begin
   rollback tran
  end

END