存储提交事务的过程 [英] store procedure for commit transaction

问题描述

我已经尝试了这个程序代码，但有些地方我得到错误;

i hav将结束语句放在冒号中并继续但也得到错误



我的程序代码是

创建程序演示
 @input int as 
声明@transcounter int 
 set @transcounter = @@ TRANCOUNT 
 IF @@ TRANCOUNT> 0 
 save tran demo 
 else 
 begin try 
 delete emp where empid ='1'
 commit tran ; 

我在这个查询中做错了什么



谢谢

解决方案

HI

试试这个

 创建  procedure  demo1 
  @ input   int   as  
 声明  @ transcounter   int  
  set  @transcounter = @@ TRANCOUNT 
  IF  @@ TRANCOUNT> 0 
  save   tran  demo 
  else  
 开始尝试
  delete  \\ temp  where  empid = '  1' 
  commit   tran  
 
  END  TRY 
  BEGIN  CATCH 
  END  CATCH; 

i have try this procedure code but some where i get error as ;
i hav put end of statement in colon and proceed but also get error

my procedure code is

create procedure demo 
@input int as 
declare @transcounter int
set @transcounter=@@TRANCOUNT
IF @@TRANCOUNT>0
save tran demo
else
begin try
delete emp where empid='1'
commit tran;

what i did wrong in this query

thanks

解决方案

HI
Try this

create procedure demo1
@input int as 
declare @transcounter int
set @transcounter=@@TRANCOUNT
IF @@TRANCOUNT>0
save tran demo
else
begin try
delete emp where empid='1'
commit tran

END TRY
BEGIN CATCH
END CATCH; 

这篇关于存储提交事务的过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！