Difference between revisions of "Dbo.uspPrintError (procedure)"
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''procedure | dbo.uspPrintError |- |} <pre> -- uspPrintError prints error information a...) |
|||
| Line 9: | Line 9: | ||
<pre> | <pre> | ||
| + | -- uspPrintError prints error information about the error that caused | ||
| + | -- execution to jump to the CATCH block of a TRY...CATCH construct. | ||
| + | -- Should be executed from within the scope of a CATCH block otherwise | ||
| + | -- it will return without printing any error information. | ||
| + | CREATE PROCEDURE [dbo].[uspPrintError] | ||
| + | AS | ||
| + | BEGIN | ||
| + | SET NOCOUNT ON; | ||
| + | |||
| + | -- Print error information. | ||
| + | PRINT 'Error ' + CONVERT(varchar(50), ERROR_NUMBER()) + | ||
| + | ', Severity ' + CONVERT(varchar(5), ERROR_SEVERITY()) + | ||
| + | ', State ' + CONVERT(varchar(5), ERROR_STATE()) + | ||
| + | ', Procedure ' + ISNULL(ERROR_PROCEDURE(), '-') + | ||
| + | ', Line ' + CONVERT(varchar(5), ERROR_LINE()); | ||
| + | PRINT ERROR_MESSAGE(); | ||
| + | END; | ||
| + | </pre> | ||
| + | |||
| + | == automatically generated == | ||
| + | |||
| + | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| + | |- | ||
| + | | '''procedure | ||
| + | | dbo.uspPrintError | ||
| + | |- | ||
| + | |||
| + | | '''Description | ||
| + | | Prints error information about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without printing any error information. | ||
| + | |- | ||
| + | |||
| + | |} | ||
| + | |||
| + | <pre> | ||
| + | |||
-- uspPrintError prints error information about the error that caused | -- uspPrintError prints error information about the error that caused | ||
-- execution to jump to the CATCH block of a TRY...CATCH construct. | -- execution to jump to the CATCH block of a TRY...CATCH construct. | ||
Revision as of 00:27, 27 November 2009
wikibot
| procedure | dbo.uspPrintError |
-- uspPrintError prints error information about the error that caused
-- execution to jump to the CATCH block of a TRY...CATCH construct.
-- Should be executed from within the scope of a CATCH block otherwise
-- it will return without printing any error information.
CREATE PROCEDURE [dbo].[uspPrintError]
AS
BEGIN
SET NOCOUNT ON;
-- Print error information.
PRINT 'Error ' + CONVERT(varchar(50), ERROR_NUMBER()) +
', Severity ' + CONVERT(varchar(5), ERROR_SEVERITY()) +
', State ' + CONVERT(varchar(5), ERROR_STATE()) +
', Procedure ' + ISNULL(ERROR_PROCEDURE(), '-') +
', Line ' + CONVERT(varchar(5), ERROR_LINE());
PRINT ERROR_MESSAGE();
END;
automatically generated
| procedure | dbo.uspPrintError |
| Description | Prints error information about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without printing any error information. |
-- uspPrintError prints error information about the error that caused
-- execution to jump to the CATCH block of a TRY...CATCH construct.
-- Should be executed from within the scope of a CATCH block otherwise
-- it will return without printing any error information.
CREATE PROCEDURE [dbo].[uspPrintError]
AS
BEGIN
SET NOCOUNT ON;
-- Print error information.
PRINT 'Error ' + CONVERT(varchar(50), ERROR_NUMBER()) +
', Severity ' + CONVERT(varchar(5), ERROR_SEVERITY()) +
', State ' + CONVERT(varchar(5), ERROR_STATE()) +
', Procedure ' + ISNULL(ERROR_PROCEDURE(), '-') +
', Line ' + CONVERT(varchar(5), ERROR_LINE());
PRINT ERROR_MESSAGE();
END;
