Sqlserver 存储过程中结合事务的代码
2022-11-12 09:52:52
内容摘要
这篇文章主要为大家详细介绍了Sqlserver 存储过程中结合事务的代码,具有一定的参考价值,可以用来参考一下。
对此感兴趣的朋友,看看idc笔记做的技术笔记!
代码如下:
--方式
文章正文
这篇文章主要为大家详细介绍了Sqlserver 存储过程中结合事务的代码,具有一定的参考价值,可以用来参考一下。
对此感兴趣的朋友,看看idc笔记做的技术笔记!
代码如下:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 | <code> --方式一 if exists (select * from dbo.sysobjects where id = object_id(N '[dbo].[USP_ProcedureWithTransaction_Demo]' ) and OBJECTPROPERTY(id, N 'IsProcedure' ) = 1) drop procedure [dbo].[USP_ProcedureWithTransaction_Demo] GO -- ============================================= -- Author: <ChengXiaoming> -- Create date : <2010-06-11> -- Description: <Demo:存储过程中使用事务> -- ============================================= Create PROCEDURE [dbo].[USP_ProcedureWithTransaction_Demo] As Begin SET XACT_ABORT ON Begin Transaction Insert Into Lock(LockTypeID) Values( 'A' )--此语句将出错,LockTypeID为Int类型 Update Lock Set LockTypeID = 2 Where LockID = 32 Commit Transaction SET XACT_ABORT OFF End GO --方式二 if exists (select * from dbo.sysobjects where id = object_id(N '[dbo].[USP_ProcedureWithTransaction_Demo]' ) and OBJECTPROPERTY(id, N 'IsProcedure' ) = 1) drop procedure [dbo].[USP_ProcedureWithTransaction_Demo] GO -- ============================================= -- Author: <ChengXiaoming> -- Create date : <2010-06-11> -- Description: <Demo:存储过程中使用事务> -- ============================================= Create PROCEDURE [dbo].[USP_ProcedureWithTransaction_Demo] As Begin Begin Transaction Insert Into Lock(LockTypeID) Values( 'A' )--此语句将出错,LockTypeID为Int类型 Update Lock Set LockTypeID = 1 Where LockID = 32 Commit Transaction If(@@ERROR <> 0) Rollback Transaction End GO --方式三 if exists (select * from dbo.sysobjects where id = object_id(N '[dbo].[USP_ProcedureWithTransaction_Demo]' ) and OBJECTPROPERTY(id, N 'IsProcedure' ) = 1) drop procedure [dbo].[USP_ProcedureWithTransaction_Demo] GO -- ============================================= -- Author: <ChengXiaoming> -- Create date : <2010-06-11> -- Description: <Demo:存储过程中使用事务> -- ============================================= Create PROCEDURE [dbo].[USP_ProcedureWithTransaction_Demo] As Begin Begin Try Begin Transaction Update Lock Set LockTypeID = 1 Where LockID = 32--此语句将出错,LockTypeID为Int类型 Insert Into Lock(LockTypeID) Values( 'A' ) Commit Transaction End Try Begin Catch Rollback Transaction End Catch End GO Exec [USP_ProcedureWithTransaction_Demo] </code> |
注:关于Sqlserver 存储过程中结合事务的代码的内容就先介绍到这里,更多相关文章的可以留意
代码注释