연구개발/DBA
에러메시지
HEAD1TON
2012. 3. 5. 21:56
DECLARE @I INT
BEGIN TRY
SET @I = 10 / 0
END TRY
BEGIN CATCH
SET @I = 0
PRINT '에러번호 : ' + CAST(ERROR_NUMBER() AS VARCHAR)
PRINT '에러메시지 : ' + ERROR_MESSAGE()
PRINT '에러심각도 : ' + CAST(ERROR_SEVERITY() AS VARCHAR)
PRINT '에러행번호 : ' + CAST(ERROR_LINE() AS VARCHAR)
PRINT '에러프로시저 : ' + ISNULL(ERROR_PROCEDURE(), '없음')
END CATCH
BEGIN TRY
SET @I = 10 / 0
END TRY
BEGIN CATCH
SET @I = 0
PRINT '에러번호 : ' + CAST(ERROR_NUMBER() AS VARCHAR)
PRINT '에러메시지 : ' + ERROR_MESSAGE()
PRINT '에러심각도 : ' + CAST(ERROR_SEVERITY() AS VARCHAR)
PRINT '에러행번호 : ' + CAST(ERROR_LINE() AS VARCHAR)
PRINT '에러프로시저 : ' + ISNULL(ERROR_PROCEDURE(), '없음')
END CATCH