Welcome to Sign in | Join | Help

Browse by Tags

All Tags » t-sql   (RSS)
When SQL Server 2005 introduced BEGIN TRY and BEGIN CATCH syntax, it was a huge improvement over the previous error handling based on @@ERROR check after each statement. Finally, T-SQL joined the rank of programming languages, no more just a data access Read More...
Do you know anybody that is interested in a 6mo-12mo contract position in Seattle (Redmond) area for a very interesting SQL Server project? Position requires good system architecture and development skills. Your main job will be writing T-SQL code for Read More...
On a project I’m currently involved with we have to handle a constant influx of audit messages for processing. The messages come from about 50 SQL Express instances located in data centers around the globe, delivered via Service Broker into a processing Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/06/11/exception-handling-and-nested-transactions/  I wanted to use a template for writing procedures that behave as intuitively as possible in regard to nested Read More...