sql script 保障一处报错,整个script 不执行
begin tran
begin try
script..........
end try
begin catch
print ERROR_MESSAGE()
ROLLBACK tran
end catch
commit
begin tran
begin try
script..........
end try
begin catch
print ERROR_MESSAGE()
ROLLBACK tran
end catch
commit