Sams Teach Yourself Transact-SQL in 21 Days, Second Edition

Day 13

Quiz

1:	What is the difference between ROLLBACK TRANSACTIONS and ROLLBACK TRANSACTIONS <savepoint>?
A1:	When you roll back a transaction to a savepoint, the transaction remains active, and any locks that existed before are still available. Without a savepoint, ROLLBACK TRANSACTIONS reverses all work in the transaction, ends the active transaction, and releases locks.
2:	How do the following settings affect your programming: set implicit_transactions on
A2:	Implicit transactions omit the automatic COMMIT record that would normally be included with single-statement transactions. Whenever you are executing single-statement transactions, you need to include an explicit COMMIT TRANSACTIONS statement to commit your work. Otherwise, your work ...