parent nodes: SQLapuntes | Ticket35611
Líneas de comienzo y fin
SET XACT_ABORT ON
SET IMPLICIT_TRANSACTIONS ON
PRINT '****** BEGIN SCRIPT ******'
IF( (SELECT SUBVERSION FROM VERSION WHERE ID_VERSION = 0) != 109 ) -- control versiones
BEGIN
PRINT 'SCRIPT **NOT** EXECUTED!!!! CURRENT VERSION IS DIFFERENT THAN NEEDED VERSION'
PRINT 'SCRIPT PASSED'
END
ELSE
BEGIN
( · · · )
( · · · )
( · · · )
( · · · )
COMMIT TRAN
PRINT 'SCRIPT EXECUTED'
PRINT 'SCRIPT PASSED'
END -- FALL THROUGHT TO END_SCRIPT
END_SCRIPT:
PRINT '****** END SCRIPT ******'
GO
SET IMPLICIT_TRANSACTIONS OFF