Try..Catch code template using transactions

• Ted Smith

  SSC Veteran

  Points: 255

  More actions

  April 12, 2006 at 9:06 am

  #172160

  Does anyone have a code template or a good example using the new Try..Catch error trapping methods with transacations in SQL Server 2005? I want to start using this.

  Thanks

   

• Walter Tucholski

  Ten Centuries

  Points: 1262

  More actions

  April 13, 2006 at 6:52 am

  #632342

  Take a look at the AdventureWorks Stored Procs such as uspUpdateEmployeeHireInfo.