BEGIN TRANSACTION DeleteSupv
--SQL语句
IF @@error<>0
BEGIN
ROLLBACK TRAN DeleteSupv
GOTO on_error
END
--SQL语句
IF @@error<>0
BEGIN
ROLLBACK TRAN DeleteSupv
GOTO on_error
END
COMMIT TRAN DeleteSupv
RETURN 1
on_error:
print 'Error occured'
转载于:https://www.cnblogs.com/brawei/archive/2007/05/16/748941.html