END TRANSACTION ? --这样是语法错误: 2005写法: begin try begin tran--语句com tran end try begin catch raiserror 50005N'出错' rollback tran end catch -----------方法2 begin tran begin try --语句end try begin tran raiserror 50005N'出错了' rollback tran end tran if @@trancount>0 commit tran
--这样是语法错误:
2005写法:
begin try
begin tran--语句com tran
end try
begin catch
raiserror 50005N'出错'
rollback tran
end catch
-----------方法2
begin tran
begin try
--语句end try
begin tran
raiserror 50005N'出错了'
rollback tran
end tran
if @@trancount>0
commit tran