|
- writing a transaction in t-sql and error handling - Stack Overflow
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
- c# - How to use TransactionScope properly? - Stack Overflow
The code within the methods you call need to be transaction aware and enlist in the active transaction This means creating or using classes which are resource managers (see Implement Your Own Resource Manager You do this by implementing IEnlistmentNotification and enlisting in the transaction When the transaction is completed, the transaction manager will call methods as defined on that
- 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 COMMIT but you'll need to go a step further and rollback if any errors occur
- How to see query history in SQL Server Management Studio
Is the query history stored in some log files? If yes, can you tell me how to find their location? If not, can you give me any advice on how to see it?
- Correct use of transactions in SQL Server - Stack Overflow
Shouldn't BEGIN TRANSACTION [Tran1] be placed inside TRY? Anyway - very simple and elegant piece of code
- 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 enterprise for longer duration than Transactional Data ) Customer: Name, Preferences Product: Name, Hierarchy Site Location: Addresses Account: Contracts Detail Transactional (Has a Time Dimension, and becomes historical
- How to check which locks are held on a table - Stack Overflow
How can we check which database locks are applied on which rows against a query batch? Any tool that highlights table row level locking in real time? DB: SQL Server 2005
- How to roll back UPDATE statement? - Stack Overflow
As a slightly modified version to the answers above, I sometimes like to use an automatically rolled back transaction in combination with the OUTPUT keyword and the INSERTED internal table to see what will actually update as a result set
|
|
|