Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE Nome_Banco
- GO
- PRINT '------------------------------------------------------------------------------------------------------------'
- PRINT 'Script base - Início: ' + CONVERT(varchar(30), GETDATE(), 9)
- PRINT '------------------------------------------------------------------------------------------------------------'
- BEGIN TRY
- COMMIT TRANSACTION
- END TRY
- BEGIN CATCH
- IF (@@TRANCOUNT > 0)
- BEGIN
- ROLLBACK TRANSACTION
- PRINT 'Erro na execução do script'
- PRINT 'Efetuado Rollback da transação'
- SELECT
- ERROR_NUMBER() AS CodigoErro,
- ERROR_MESSAGE() AS MensagemErro,
- ERROR_LINE() AS LinhaErro
- END
- END CATCH
- GO
- PRINT '------------------------------------------------------------------------------------------------------------'
- PRINT 'Script base - FIM: ' + CONVERT(varchar(30), GETDATE(), 9)
- PRINT '------------------------------------------------------------------------------------------------------------'
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement