在SQL Server 2005中用如下语句可以获得错误的级别、消息编号、消息内容等信息,但对于对象不存在等错误没法弄,不知道是什么原因
BEGIN TRY
-- Generate a divide-by-zero error.
SELECT 1/0 --这里的错误可以体现在下面的Catch结果,返回Delphi中有两个数据集,一个是空数据集,一个是错误信息数据集
END TRY
BEGIN CATCH
select
ERROR_NUMBER() as [number],
ERROR_LINE() as [line],
ERROR_SEVERITY() as [severity],
ERROR_MESSAGE() as [message],
ERROR_PROCEDURE() as [procedure],
ERROR_STATE() as [state]
END CATCH