您现在的位置是：网站首页> 编程资料编程资料

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

2023-05-26 413人已围观

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

--方式一 
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: 
-- Create date: <2010-06-11>
-- Description: 
-- ============================================= 
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: 
-- Create date: <2010-06-11>
-- Description: 
-- ============================================= 
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: 
-- Create date: <2010-06-11>
-- Description: 
-- ============================================= 
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] 

您可能感兴趣的文章:

上一篇：MSSQL SERVER 2005 数学函数整理_MsSql_

下一篇：SQLServer触发器创建、删除、修改、查看示例代码_MsSql_

您现在的位置是：网站首页> 编程资料编程资料

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

相关内容

点击排行

本栏推荐

猜你喜欢