sqlserver 2005中try---catch语句

sql server 2005中新增加的try catch，可以很容易捕捉异常了

 

 

begin try
declare @x int
   set @x=1/0
   print '出错啦'
end try
begin catch
print '出错抛出了'
select error_number()
end catch
print '继续执行.....'

 

 

出错抛出了
继续执行.....

begin try
declare @x int
   set @x=1/0
end try
begin catch
SELECT ERROR_NUMBER() ERNumber,
ERROR_SEVERITY() Error_Severity,
ERROR_STATE() Error_State,
ERROR_PROCEDURE() Error_Procedure,
ERROR_LINE() Error_Line,
ERROR_MESSAGE() Error_Message
end catch