有显式事务的两个存储过程的相互调用

2004-04-08 10:02:15 112 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Vivado图形化界面烧写MCS文件到SPI FLASH全流程（附常见报错解决方案）本文详细介绍了使用Vivado图形化界面将MCS文件烧录至SPI FLASH的完整操作流程。内容涵盖从环境准备、MCS文件生成到硬件连接与烧写的每一步，并针对SPI总线宽度报错、FLASH型号识别失败等常见问题提供了深度解决方案，帮助用户高效完成FPGA配置，摆脱对TCL命令行的依赖。阅读详情

现在我有一个这样的问题：我在是使用存储过程的时候遇到这样的问题，我这两个存储过程都用了Begin tran 和rollback tran，commit tran，在一个存储过程中对另外一个调用，在调用的过程中出现这样的错误报告：当前的@@transcount是0，但它应该是1，我在调试的时候发现：我在启动第一个事务是@@transcount增加1，但是当它在调用第二个存储过程是，当运行到begin tran 是它的@@transcount没有象预期的那样加1，所以在被调用的存储过程中遇到commit tran 是@@transcount就减1，变成0，回到第一个存储过程的commit tran 时，就出现那样的错误！请高手指点！

...全文

从OVITO可视化到LAMMPS计算：ATOMSK堆垛层错模型的全流程避坑指南本文提供了一份从ATOMSK建模、OVITO可视化诊断到LAMMPS计算的堆垛层错模型全流程实战指南。重点解析了构建“计算友好”模型的核心矛盾，并详细演示了如何通过添加真空层、原子包裹和能量最小化等关键步骤，规避周期性边界条件带来的非物理相互作用，确保广义层错能计算的可靠性与可复现性。阅读详情

dj0109

疑难问题 22,298 成员 121,727 内容

+ 关注 + 加入社区

切换为时间正序

siemun2002 2004-04-09

打赏
举报

调试了一下：
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[a]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[a]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[b]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[b]
GO

CREATE TABLE [dbo].[a] (
[a] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[b] (
[b] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[test_1]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[test_1]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[test_2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[test_2]
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

CREATE PROCEDURE test_1 AS
begin
declare @transcount int
select @transcount =@@trancount
if @transcount>0
begin
save tran tran_1
print @transcount
end
else
begin
begin tran tran_2
insert into b (b) values ( 'b')
if @@error<>0
begin
rollback tran tran_2
return
end
else
commit tran tran_2
end
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

CREATE PROCEDURE test_2 AS
begin
declare @transcount int
select @transcount =@@trancount
if @transcount>0
save tran tran_2
else
begin tran tran_2

insert into a (a) values ( 'a')
exec test_1
if @@error<>0
begin
rollback tran tran_2
return
end
else
commit tran tran_2
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

exec test_2

dj0109 2004-04-08

打赏
举报

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[a]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[a]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[b]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[b]
GO

CREATE TABLE [dbo].[a] (
[a] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[b] (
[b] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[test_1]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[test_1]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[test_2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[test_2]
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

CREATE PROCEDURE test_1 AS
begin
declare @transcount int
select @transcount =@@trancount
if @transcount>0
save tran tran_1
else
begin tran tran_1

insert into b (b) values ( 'b')
if @@error<>0
begin
rollback tran tran_1
return
end
else
commit tran tran_1
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

CREATE PROCEDURE test_2 AS
begin
declare @transcount int
select @transcount =@@trancount
if @transcount>0
save tran tran_2
else
begin tran tran_2

insert into a (a) values ( 'a')
exec test_1
if @@error<>0
begin
rollback tran tran_2
return
end
else
commit tran tran_2
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

简单的代码，@@transcount是全局变量呀

LoveSQL 2004-04-08

打赏
举报

应该是@@transcount有个作用域的问题吧

zjcxc 2004-04-08

打赏
举报

最好将代码贴出来看看

有显式事务的两个存储过程的相互调用

相关推荐