On error display error message FIRST and then return (MS Sql Server)

Question

Begin Try
exec @sql
End Try

Begin Catch
Display error message (How to?)
return
End Catch

Now, on error with the exec @sql statement, I want it to display the error message first and then end the code.

Elmer · Accepted Answer · 2014-01-16 09:38:48Z

1

declare @sql varchar(100) = 'Select 1/0'  
Begin Try  
exec(@sql) 
End Try

Begin Catch
print 'error='+ERROR_MESSAGE()
return
End Catch

answered Jan 16, 2014 at 9:38

Elmer

2723 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gemini · Accepted Answer · 2014-01-16 10:06:49Z

1

To get the error message generated by system

  declare @sql varchar(100) = 'Select 1/0'  
  Begin Try  
        exec(@sql) 
  End Try  
  Begin Catch
        print ERROR_MESSAGE()
  return

answered Jan 16, 2014 at 10:06

Gemini

891 bronze badge