欧美精品久久久久久久久老牛影院 ,久久久久久亚洲精品不卡4k岛国,精品国产乱码久久久久久免费

復(fù)制代碼代碼如下:

 
--方式一 
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:存儲(chǔ)過(guò)程中使用事務(wù)> 
-- ============================================= 
Create PROCEDURE [dbo].[USP_ProcedureWithTransaction_Demo] 
As 
Begin 
SET XACT_ABORT ON 
Begin Transaction 
Insert Into Lock(LockTypeID) Values('A')--此語(yǔ)句將出錯(cuò)，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:存儲(chǔ)過(guò)程中使用事務(wù)> 
-- ============================================= 
Create PROCEDURE [dbo].[USP_ProcedureWithTransaction_Demo] 
As 
Begin 
Begin Transaction 
Insert Into Lock(LockTypeID) Values('A')--此語(yǔ)句將出錯(cuò)，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:存儲(chǔ)過(guò)程中使用事務(wù)> 
-- ============================================= 
Create PROCEDURE [dbo].[USP_ProcedureWithTransaction_Demo] 
As 
Begin 
Begin Try 
Begin Transaction 
Update Lock Set LockTypeID = 1 Where LockID = 32--此語(yǔ)句將出錯(cuò)，LockTypeID為Int類型 
Insert Into Lock(LockTypeID) Values('A') 
Commit Transaction 
End Try 
Begin Catch 
Rollback Transaction 
End Catch 
End 
GO 

Exec [USP_ProcedureWithTransaction_Demo] 

您可能感興趣的文章:

c#實(shí)現(xiàn)sqlserver事務(wù)處理示例
SQL Server觸發(fā)器及觸發(fā)器中的事務(wù)學(xué)習(xí)
sqlserver中的事務(wù)和鎖詳細(xì)解析
SQLSERVER分布式事務(wù)使用實(shí)例
淺析SQL Server中包含事務(wù)的存儲(chǔ)過(guò)程
SQLServer存儲(chǔ)過(guò)程中事務(wù)的使用方法
sqlserver 函數(shù)、存儲(chǔ)過(guò)程、游標(biāo)與事務(wù)模板
SQL Server存儲(chǔ)過(guò)程中編寫事務(wù)處理的方法小結(jié)
Sql Server中的事務(wù)介紹
Sql Server事務(wù)語(yǔ)法及使用方法實(shí)例分析

標(biāo)簽：澳門晉城保定三明嘉興合肥日照延邊

巨人網(wǎng)絡(luò)通訊聲明：本文標(biāo)題《Sqlserver 存儲(chǔ)過(guò)程中結(jié)合事務(wù)的代碼》，本文關(guān)鍵詞 Sqlserver,存儲(chǔ),過(guò)程中,結(jié)合,；如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問(wèn)題，煩請(qǐng)?zhí)峁┫嚓P(guān)信息告之我們，我們將及時(shí)溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò)，涉及言論、版權(quán)與本站無(wú)關(guān)。