Error Handling & Transactional Handling in SQL Server 2008.

Question

Hi All,

Can anybody provide me what are the difference in "Error Handling" & "Transactional Handling " of SQL Server 2005 & SQL Server 2008? What are new functions, features comes in SQL Server 2008 for handling Error as well as transactional handling.

Thanks & Regards,
Priyaa Saxena

Answer 1

Nothing new that I can think of. The exception could possibly be the new MERGE DML command which allow you to do several operations in one command with then is automatically transaction protected - in earlier releases that required several commands with begin tran/try/catch etc.

---

Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi

Answer 2

Priyaa,

As mentioned by Tibor, the MERGE statement, brand-new to SQL Server 2008, related link: Extracting insert, update, delete rowcounts from T-SQL MERGE .

MERGE can be used for conditional UPDATE/INSERT (UPSERT) and for synching two tables, related link:

Inserting, Updating, and Deleting Data by Using MERGE .


Error handling related link: SQL Server 2008 error handling best practice .

---

Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com

Answer 3

Priyaa,

I havent seen anything new with the error handling part.

With transaction handling, there are some features that do multiple row updates as a single transaction in SQL Server.

The MERGE statement given above is a very good example. Apart from that you also have table value parameters that now support set based operations so in effect you could update an entire table in one go in a single transaction.

Then you have row constructors.

I have a series of posts in my blog http://vaideeswaranr.blogspot.com on SQL Server 2008 and the new features. Hope this helps