Should I Handle Errors in Transact SQL?

SQL Server 2012 brings a new capability for error handling - rethrowing the original error. Is the rethrowed error really the original one? Why you have to be careful with THROW?  What should I test if I implement tRY/CATCH error handling in SQL Server? Finally, should I handle Transact SQL errors at all?

In this session we will answer these questions and explain how SQL Server database engine handles errors. We'll discuss best practices and demonstrate common mistakes and misunderstandings in error handling.
Presented by Milos Radivojevic at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Milos Radivojevic is a database developer and consultant, speaker, and trainer and is located in Vienna, Austria. He has been working with SQL Server over 10 years. He is MCT and MCITP for SQL Server 2008 and specializes in SQL Server for application developers and performance and query tuning.In March 2013 he joined's database development team.
  • Video
    The video is not available to view online.