Transaction Control Language

Transaction Control Language

1. Save Ponit

   • Update Tramite Set Nombre = ´Juan´ Wher tipo tramite Like ´Licencia´; SavePoint Tramite_sal
   • Update Biblioteca Set Nombre = ´Fanáticos de la lectura´ Wher tipo usuario Like ´ID_usuario´; SavePoint Biblioteca_sal
   • Update Colegio Set Nombre = ´Andres Uzeda´ Wher tipo alumno Like ´ID_alumno´; SavePoint Colegio_sal

2. Roll Back

   • Rollback To Savepoint Tramite_sal
   • Rollback To Savepoint Biblioteca_sal
   • Rollback To Savepoint Colegio_sal

3. Commit

   • Begin TranExterna Select Tamaño_cm Insert Int To Mascotas Values (30) Commit TranExterna
   • Begin transaction Delete From CandidatoTrabajo WHERE ID = 13; Commit Transaction;
   • Begin transaction Update cuentas Set balance WHERE nombre_cliente = ´Antonio´; Commit Transaction;