Avatar of CraigLazar

asked on 

error hsndling in SQL stored |Proc

What is the best way to hanlde error handling in a sp?

I have a 11 Insert Statements that follow one after the other, how do i reverse my hole process if oneof the copies fail?
I am thinking of using Begin Tranasaction and Commit Transaction, at what point if it fails can i call RollBack Transaction?

thanks allot

Microsoft SQL Server 2005Microsoft SQL Server 2008SQL

Avatar of undefined
Last Comment

8/22/2022 - Mon