begin try
select 1/0
end try
begin catch
select
error_number() as ‘number‘,
error_line() as ‘line‘,
error_message() as ‘message‘,
error_severity() as ‘severity‘,
error_state() as ‘state‘
end catch
原文：http://www.cnblogs.com/woshare/p/4307302.html