ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
dbo.uspPrintError_(procedure)
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Procedure''' | dbo.uspPrintError |- valign="top" | '''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. |} === Source === {{{{<nowiki> -- 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; </nowiki>}}}} === Dependencies === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Reference Type''' | '''Object Type''' | '''Referencing Object''' | '''Child Type''' | '''Child Object''' |- valign="top" | Execute | Procedure | [[dbo.uspLogError_(procedure)|dbo.uspLogError]] | | |- valign="top" | Execute | Table | [[Production.WorkOrder_(table)|Production.WorkOrder]] | Trigger | iWorkOrder |- valign="top" | Execute | Table | [[Production.WorkOrder_(table)|Production.WorkOrder]] | Trigger | uWorkOrder |- valign="top" | Execute | Table | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]] | Trigger | iPurchaseOrderDetail |- valign="top" | Execute | Table | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]] | Trigger | uPurchaseOrderDetail |- valign="top" | Execute | Table | [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]] | Trigger | uPurchaseOrderHeader |- valign="top" | Execute | Table | [[Purchasing.Vendor_(table)|Purchasing.Vendor]] | Trigger | dVendor |- valign="top" | Execute | Table | [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]] | Trigger | iduSalesOrderDetail |- valign="top" | Execute | Table | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] | Trigger | uSalesOrderHeader |- valign="top" | Execute | Table | [[Sales.Store_(table)|Sales.Store]] | Trigger | iStore |} == automatically generated == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''procedure''' | dbo.uspPrintError |- valign="top" | '''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. |- |} {{{{<nowiki> -- 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; </nowiki>}}}} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Reference Type''' | '''Object Type''' | '''Referencing Object''' | '''Child Type''' | '''Child Object''' |- | Execute | Procedure | [[dbo.uspLogError_(procedure)|dbo.uspLogError]] |- | Execute | Table | [[Production.WorkOrder_(table)|Production.WorkOrder]] | Trigger | iWorkOrder |- | Execute | Table | [[Production.WorkOrder_(table)|Production.WorkOrder]] | Trigger | uWorkOrder |- | Execute | Table | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]] | Trigger | iPurchaseOrderDetail |- | Execute | Table | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]] | Trigger | uPurchaseOrderDetail |- | Execute | Table | [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]] | Trigger | uPurchaseOrderHeader |- | Execute | Table | [[Purchasing.Vendor_(table)|Purchasing.Vendor]] | Trigger | dVendor |- | Execute | Table | [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]] | Trigger | iduSalesOrderDetail |- | Execute | Table | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] | Trigger | uSalesOrderHeader |- | Execute | Table | [[Sales.Store_(table)|Sales.Store]] | Trigger | iStore |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.