Sunday, December 19, 2010

Database Transactions-

rollback-
Syntax- ROLLBACK
--This SQL command is used to undo the current transaction

savepoint-
Syntax- SAVEPOINT savepoint_name
--This is used to identify a point in a transaction to which we can later rollback.

commit
Syntax - COMMIT
--This command is used to make all changes permanent in database and also marks the end of transaction.
 


No comments:

Post a Comment