SQL 自定义存储过程报错

begin catch
DECLARE @ErrMsg nvarchar(4000), @ErrSeverity int
  SELECT @ErrMsg = ' SP Error: '+ERROR_MESSAGE(),
         @ErrSeverity = ERROR_SEVERITY()

  RAISERROR(@ErrMsg, @ErrSeverity, 1)
end catch

 

posted @ 2015-09-30 15:36  bobo-bobo  阅读(332)  评论(0编辑  收藏  举报