Logo 
Search:

SQL FAQ

Submit Interview FAQ
Home » Interview FAQ » SQLRSS Feeds

Can savepoints be used to "save off" portions of a transaction? Why or why not?

  Shared By: Shruti Sharma    Date: Dec 21    Category: SQL    Views: 1035

Answer:

Can savepoints be used to "save off" portions of a transaction? Why or why not?

Yes. Savepoints allow the programmer to save off statements within a transaction. If desired, the transaction can then be rolled back to this savepoint instead of to the beginning of the transaction.

Share: 
 



Your Comment
  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].


Tagged: