SQL Server save transaction
准备:
create table Nums(X int);
目的:只向表中插入一行。
-------------------------------------------------------------------------------------------------------------------------------------
begin transaction tran_A -- 最好是为事务定义一个名字。
insert into Nums(X) values(9);
save transaction save_tran; --定义一个事务的保存点、当要回滚事务时,可以回滚到这里。
insert into Nums(X) values(4),(3),(2),(1);
rollback transaction save_tran;--回滚事务到保存点
commit transaction tran_A;-- 提交事务。
go
USE [warm]
GO
/****** Object: StoredProcedure [dbo].[P_GetYID] Script Date: 06/15/2019 20:19:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create PROCEDURE [dbo].[P_GetYID]
@VouID int output
AS
BEGIN
declare @TC int
select @TC = @@TRANCOUNT
if @TC = 0
begin transaction
else
save transaction T_BAK
-------------------------------------------------
update T_VouID_Bank with(tablockx) set I_VouID = I_VouID + 1,@VouID = I_VouID
if @@ROWCOUNT <> 1 or @@ERROR <> 0 goto ERR
-------------------------------------------------
if @TC = 0
commit transaction
return 0
ERR:
if @TC = 0
rollback transaction
else
rollback transaction T_BAK
return 1
END
GO
反射引发的错误“reflection Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.”
机械键盘理解的几个误区和保养方法
Asp.Net MVC中不指定View Name时如何返回ActionResult的
[通告]Nuget服务宕机,出现 503 Server Unavailable 错误无法编译及解决方法
MVC标签链接切换帮助类: TabLink
[Centos 6.2] centos 6.2(64位)网络配置
Linux(Ubuntu)设置环境变量(转载)
COPYONWRITE 原理
[Linux 技巧] linux screen 命令详解