SQL Server error handling

The next session was held by Bob Beauchemin, a great speaker. I clearly remember hearing Beuchemin somewhere else, I just can't remember where exactly. Anyways, the session was about SQL Server error handling in T-SQL and SQLCLR.

Without going into too much detail (as the amount of detail was quite overwhelming), it was about how - well, yes, crappy - the try/catch error handling is implemented in SQL Server 2005. Also we got an introduction into the various kinds of errors that may be thrown, and the results of such errors. For instance, which errors stops a batch execution, and which execute until the point of error and then stop? An example of a weird SQL Server behaviour is in the case of passing the wrong number of arguments into stored procedures. Passing in too many parameters versus too few throws two different errors, one stops the batch execution, the other doesn't, makes sense eh?

I highly recommend that you stop by Beauchemins blog and look at his work, it's quite impressive.