一个标准存储过程和事务回滚的语法

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

ALTER   procedure adduser
as
begin
 begin tran
 
 begin
  insert users ([name])values('78');
  
  insert users ([name])values('90');
  
 commit tran 
 end
 print @@error;
 if @@error<>0
 begin
  rollback tran
  return
 end
end

 

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO