久了没写Sql 连基本的T-SQL 编程都忘了,这里记录下T-Sql 写存储过程中事务和异常处理的一般编程实践:
begin tran
begin try
update statement 1 ...
delete statement 2 ...
end try
begin catch
if @@trancount > 0
rollback tran
end catch
if @@trancount > 0
commit tran
end tran
go