try catch example in sql

 

create procedure  trycatch

as begin

try

select 1/0

end try

begin catch

select error_number()  as errornumber,error_State() as errorstate,

error_procedure() as errorprocedure,error_line() as errorline,

error_message() as errormessage;

end catch

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s