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