频道导航

Sqlserver 存储过程中结合事务的代码

2019-01-04 MsSQL 前端之家

前端之家收集整理的这篇文章主要介绍了Sqlserver 存储过程中结合事务的代码，前端之家小编觉得挺不错的，现在分享给大家，也给大家做个参考。

<div class="codetitle"><a style="CURSOR: pointer" data="38354" class="copybut" id="copybut38354" onclick="doCopy('code38354')"> 代码如下:

<div class="codebody" id="code38354"> @H_3013@--方式一 @H301_3@if exists (select from dbo.sysobjects where id = object_id(N'[dbo].[USP_ProcedureWithTransactionDemo]') and OBJECTPROPERTY(id,N'IsProcedure') = 1) @H301_3@drop procedure [dbo].[USP_ProcedureWithTransactionDemo] @H3013@GO @H3013@-- ============================================= @H3013@-- Author: @H3013@-- Create date: <2010-06-11> @H3013@-- Description: <Demo:存储过程中使用事务> @H3013@-- ============================================= @H301_3@Create PROCEDURE [dbo].[USP_ProcedureWithTransactionDemo] @H3013@As @H3013@Begin @H301_3@SET XACTABORT ON @H3013@Begin Transaction @H3013@Insert Into Lock(LockTypeID) Values('A')--此语句将出错，LockTypeID为Int类型 @H3013@Update Lock Set LockTypeID = 2 Where LockID = 32 @H3013@Commit Transaction @H301_3@SET XACTABORT OFF @H3013@End @H3013@GO --方式二 @H301_3@if exists (select from dbo.sysobjects where id = object_id(N'[dbo].[USP_ProcedureWithTransactionDemo]') and OBJECTPROPERTY(id,N'IsProcedure') = 1) @H301_3@drop procedure [dbo].[USP_ProcedureWithTransactionDemo] @H3013@GO @H3013@-- ============================================= @H3013@-- Author: @H3013@-- Create date: <2010-06-11> @H3013@-- Description: <Demo:存储过程中使用事务> @H3013@-- ============================================= @H301_3@Create PROCEDURE [dbo].[USP_ProcedureWithTransactionDemo] @H3013@As @H3013@Begin @H3013@Begin Transaction @H3013@Insert Into Lock(LockTypeID) Values('A')--此语句将出错，LockTypeID为Int类型 @H3013@Update Lock Set LockTypeID = 1 Where LockID = 32 @H3013@Commit Transaction @H3013@If(@@ERROR <> 0) @H3013@Rollback Transaction @H3013@End @H3013@GO --方式三 @H301_3@if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[USP_ProcedureWithTransactionDemo]') and OBJECTPROPERTY(id,N'IsProcedure') = 1) @H301_3@drop procedure [dbo].[USP_ProcedureWithTransactionDemo] @H3013@GO @H3013@-- ============================================= @H3013@-- Author: @H3013@-- Create date: <2010-06-11> @H3013@-- Description: <Demo:存储过程中使用事务> @H3013@-- ============================================= @H301_3@Create PROCEDURE [dbo].[USP_ProcedureWithTransactionDemo] @H3013@As @H3013@Begin @H3013@Begin Try @H3013@Begin Transaction @H3013@Update Lock Set LockTypeID = 1 Where LockID = 32--此语句将出错，LockTypeID为Int类型 @H3013@Insert Into Lock(LockTypeID) Values('A') @H3013@Commit Transaction @H3013@End Try @H3013@Begin Catch @H3013@Rollback Transaction @H3013@End Catch @H3013@End @H301_3@GO Exec [USP_ProcedureWithTransactionDemo] @H301_3@

原文链接：https://www.f2er.com/mssql/64122.html

事务事务存储过程