没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
CREATE TABLE ErrorLog
(
ID INT IDENTITY (1,1) NOT NULL,
ErrorNumber INT,
ErrorMessage VARCHAR(1000),
ErrorSeverity INT,
ErrorState INT,
ErrorLine INT,
ErrorProcedure VARCHAR(128),
ErrorDate datetime
);
CREATE PROCEDURE CatchErrorDemo
AS --相关业务逻辑
BEGIN TRY
SELECT 1 / 0;
END TRY
--相关错误捕获
BEGIN CATCH
PRINT 'Error Number:' + CAST(ERROR_NUMBER() AS VARCHAR(10));
PRINT 'Error Serverity: ' + CAST(ERROR_SEVERITY() AS VARCHAR(10));
PRINT 'Error State: ' + CAST(ERROR_STATE() AS VARCHAR(10));
PRINT 'Error Procedure: ' + ERROR_PROCEDURE();
PRINT 'Error Line: ' + CAST(ERROR_LINE() AS VARCHAR(10));
PRINT 'Error Message: ' + ERROR_MESSAGE();
INSERT INTO ErrorLog
( ErrorNumber ,
ErrorSeverity ,
ErrorState ,
(
ID INT IDENTITY (1,1) NOT NULL,
ErrorNumber INT,
ErrorMessage VARCHAR(1000),
ErrorSeverity INT,
ErrorState INT,
ErrorLine INT,
ErrorProcedure VARCHAR(128),
ErrorDate datetime
);
CREATE PROCEDURE CatchErrorDemo
AS --相关业务逻辑
BEGIN TRY
SELECT 1 / 0;
END TRY
--相关错误捕获
BEGIN CATCH
PRINT 'Error Number:' + CAST(ERROR_NUMBER() AS VARCHAR(10));
PRINT 'Error Serverity: ' + CAST(ERROR_SEVERITY() AS VARCHAR(10));
PRINT 'Error State: ' + CAST(ERROR_STATE() AS VARCHAR(10));
PRINT 'Error Procedure: ' + ERROR_PROCEDURE();
PRINT 'Error Line: ' + CAST(ERROR_LINE() AS VARCHAR(10));
PRINT 'Error Message: ' + ERROR_MESSAGE();
INSERT INTO ErrorLog
( ErrorNumber ,
ErrorSeverity ,
ErrorState ,
ErrorProcedure ,
ErrorLine ,
ErrorMessage ,
ErrorDate
)
VALUES ( ERROR_NUMBER() ,
ERROR_SEVERITY() ,
ERROR_STATE() ,
ERROR_PROCEDURE() ,
ERROR_LINE() ,
ERROR_MESSAGE() ,
GETDATE()
)
END CATCH;
ALTER PROC usp_AccountTransaction
@AccountNum INT,
@Amount DECIMAL
AS
BEGIN
BEGIN TRY --Start the Try Block..
ErrorLine ,
ErrorMessage ,
ErrorDate
)
VALUES ( ERROR_NUMBER() ,
ERROR_SEVERITY() ,
ERROR_STATE() ,
ERROR_PROCEDURE() ,
ERROR_LINE() ,
ERROR_MESSAGE() ,
GETDATE()
)
END CATCH;
ALTER PROC usp_AccountTransaction
@AccountNum INT,
@Amount DECIMAL
AS
BEGIN
BEGIN TRY --Start the Try Block..
剩余6页未读,继续阅读
资源评论
小幸福520
- 粉丝: 2
- 资源: 21
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功