What is TCL or Transaction Control Command in SQL Server


Transaction Control (TCL)

TCL Statements are used to Manage the changes Made by DML Statements.  
 It allows statements to be Grouped Together into Logical Transactions.

Examples:

COMMITSaves  After  Finished
ROLLBACKRestore Database to Original Since the Last COMMIT

SAVEPOINTIdentify a Point in a Transaction
SET TRANSACTIONChange Transaction Like Isolation level.


0 comments:

Post a Comment