Sybase SQL transaction model is used by SQL Server. Here are the transaction processing statements in this model:
BEGIN TRANSACTION: It is used to indicate the beginning of a transaction. In Sybase model, to begin a transaction a BEGIN TRANSACTION statement is required.
COMMIT TRANSACTION: COMMIT TRANSACTION statement informs the database management system that a transaction was successful. All the changes are made permanent.
SAVE TRANSACTION: It is used to create a save point with name in between of a transaction. By doing this if there’s a problem in transaction then the entire transaction doesn’t have to be aborted. It will simply return to the previous saved point.
ROLLBACK TRANSACTION: If there is a named save point, ROLLBACK TRANSACTION statement is used to roll back to the point where the SAVE TRANSACTION statement was executed. If there’s no named save point, it rolls back from all the changes and database is restored to as it was in the BEGIN TRANSACTION state.