How To trap error in SQL Server?

E.g :

While executing a procedure an error comes at first part of the procedure. So when error comes i don't want to execute first part, quit from there then second part of the procedure should be executed.

Normally when error comes subsequent statement will not be executed.How to handle this error.

Regards

Ashik Nihal M.s

print '****** SQL Server 2000/2005 using @@Error'

declare @myerror bit --0 success, 1 -- failure

declare @x int

declare @y int

declare @Results int

set @x = 2

set @y = 0

set @myerror =0

if @myerror = 0

begin

--Continue doing part

--1st part of step 1

set @Results = @x / @y

set @myError = @@error -- Must be called as the very next statment

--2nd part of step 1

set @Results = @x + @y

end

print 'Part 2 results: ' + cast(@Results as varchar(10))

print '****** SQL Server 2005 using try catch'

set @x = 2

set @y = 0

begin try

--1st part of step 1

set @Results = @x / @y

set @myError = @@error -- Must be called as the very next statment

--2nd part of step 1

set @Results = @x + @y

end try

begin catch

Print 'Error occured in first part of procedure'

end catch

begin try

print 'Part 2 results: ' + cast(@Results as varchar(10))

end try

begin catch

print 'error occured in 2nd part of procedure'

end catch