SQL存储过程事务写法。

最新推荐文章于 2021-02-02 04:28:32 发布

diaochou1143

最新推荐文章于 2021-02-02 04:28:32 发布

阅读量65

点赞数

原文链接：http://www.cnblogs.com/humin/archive/2012/08/25/2656726.html

版权

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE PROCEDURE <Procedure_Name, sysname, ProcedureName>
-- Add the parameters for the stored procedure here
<@Param1, sysname, @p1> <Datatype_For_Param1, , int> = <Default_Value_For_Param1, , 0>,
<@Param2, sysname, @p2> <Datatype_For_Param2, , int> = <Default_Value_For_Param2, , 0>
AS
BEGIN

　　SET XACT_ABORT ON--SQL 语句产生运行时错误，整个事务将终止并回滚

　　begin tran --在这里需要开始事务

-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here
SELECT <@Param1, sysname, @p1>, <@Param2, sysname, @p2>

commit tran --如果无错，直接提交该事务。
END
GO

转载于:https://www.cnblogs.com/humin/archive/2012/08/25/2656726.html