TCL

TCL (Transaction Control Language)

• COMMIT

  • Autocommit

• ROLLBACK

• SAVEPOINT

• To start a transaction

START TRANSACTION;
 
-- Autocommit
SELECT @@AUTOCOMMIT;
 
SET AUTCOMMIT = 0; -- autocommit to false
SET AUTCOMMIT = 1; -- autocommit to true
 
-- COMMIT. To finish a transaction, use commit or rollback
COMMIT;
 
-- SAVEPOINT
SAVEPOINT PuntoGuardado1;
 
-- ROLLBACK. start again the transaction
ROLLBACK;
ROLLBACK TO SAVEPOINT PuntoGuardado2;
 
EXEC sp_columns peliculas