用来捕获异常和处理异常语句。
语法
BEGIN TRY
{sql_statement | statement_block} //执行语句
END TRY
BEGIN CATCH
{sql_statement | statement_block} //发生错误后处理语句
END CATCH
示例:
Begin try
Declare @num int
Set @num=1/0
Select @num
End try
Begin catch
Select error_like() as '错误行数',error_message() '错误消息' // 提示出现错误的行数和错误消息
End catch