Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BEGIN TRANSACTION SCHEDULEDELETE
- BEGIN TRY
- DELETE -- delete commands full SQL cut out
- DELETE -- delete commands full SQL cut out
- DELETE -- delete commands full SQL cut out
- PRINT 'X rows deleted. Please commit or rollback.' --calculation cut out.
- END TRY
- BEGIN CATCH
- SELECT
- ERROR_NUMBER() AS ErrorNumber,
- ERROR_SEVERITY() AS ErrorSeverity,
- ERROR_STATE() AS ErrorState,
- ERROR_PROCEDURE() AS ErrorProcedure,
- ERROR_LINE() AS ErrorLine,
- ERROR_MESSAGE() AS ErrorMessage
- ROLLBACK TRANSACTION SCHEDULEDELETE
- PRINT 'Error detected, all changes reversed.'
- END CATCH
- --COMMIT TRANSACTION SCHEDULEDELETE --Run this if count correct.
- --ROLLBACK TRANSACTION SCHEDULEDELETE --Run this if there is any doubt whatsoever.
- BEGIN TRY
- BEGIN TRANSACTION SCHEDULEDELETE
- DELETE -- delete commands full SQL cut out
- DELETE -- delete commands full SQL cut out
- DELETE -- delete commands full SQL cut out
- COMMIT TRANSACTION SCHEDULEDELETE
- PRINT 'X rows deleted. Operation Successful Tara.' --calculation cut out.
- END TRY
- BEGIN CATCH
- IF (@@TRANCOUNT > 0)
- BEGIN
- ROLLBACK TRANSACTION SCHEDULEDELETE
- PRINT 'Error detected, all changes reversed'
- END
- SELECT
- ERROR_NUMBER() AS ErrorNumber,
- ERROR_SEVERITY() AS ErrorSeverity,
- ERROR_STATE() AS ErrorState,
- ERROR_PROCEDURE() AS ErrorProcedure,
- ERROR_LINE() AS ErrorLine,
- ERROR_MESSAGE() AS ErrorMessage
- END CATCH
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement