How to rollback or commit a transaction in SQL Server
The good news is a transaction in SQL Server can span multiple batches (each exec is treated as a separate batch.) You can wrap your EXEC statements in a BEGIN TRANSACTION and
Related Topics:
Transaction Terms 100foot Smart
concurrency
A transaction is a unit of work that you want to treat as "a whole." It has to either happen in full or not at all. A classical example is transferring money from one bank account to another. To
writing a transaction in t-sql and error handling
Do u think there is a better way to write a transaction in t-sql? Is there a better approach that improves maintainability and performance of the application that uses this transaction? -- Descri...
What does a transaction around a single statement do?
BEGIN TRANSACTION / COMMIT "extends" this locking functionality to the work done by multiple statements, but it adds nothing to single statements. However, the database transaction log is
Correct use of transactions in SQL Server
Add a try/catch block, if the transaction succeeds it will commit the changes, if the transaction fails the transaction is rolled back:
When to use Transactions in SQL Server
When is an appropriate time to use a Transaction? As a follow-up question, if I use them, how can I use them in such a way as to ONLY prevent other SPs from accessing the same data at the same time in
Database ginTransaction vs Transactions.TransactionScope
TransactionScope offer broader options, BeginTransaction has a simpler API TransactionScope allows to customize the transaction timeout, support nested transactions with various
What is the difference between a query and transaction in SQL?
The three key operations on a transactions are: BEGIN TRANSACTION: Tell the database that a transaction is beginning. All changes within the transaction are invisible to other
Difference between transactional and non-transactional
I think the best way to understand the difference between Transactional and Non-Transactional Data is through examples Non -Transactional (These information are relevant to