Has DB Access | |
Login | |
System Object |
Has DB Access | |
Login | |
System Object |
Table | Description |
---|---|
dbo.AWBuildVersion | Current version number of the AdventureWorks 2016 sample database. |
dbo.DatabaseLog | Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog. |
dbo.ErrorLog | Audit table tracking errors in the the AdventureWorks database that are caught by the CATCH block of a TRY...CATCH construct. Data is inserted by stored procedure dbo.uspLogError when it is executed from inside the CATCH block of a TRY...CATCH construct. |
Stored Procedure | Description |
---|---|
dbo.uspGetBillOfMaterials | Stored procedure using a recursive query to return a multi-level bill of material for the specified ProductID. |
dbo.uspGetEmployeeManagers | Stored procedure using a recursive query to return the direct and indirect managers of the specified employee. |
dbo.uspGetManagerEmployees | Stored procedure using a recursive query to return the direct and indirect employees of the specified manager. |
dbo.uspGetWhereUsedProductID | Stored procedure using a recursive query to return all components or assemblies that directly or indirectly use the specified ProductID. |
dbo.uspLogError | Logs error information in the ErrorLog table 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 inserting error information. |
dbo.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. |
dbo.uspSearchCandidateResumes |
User Defined Function | Description |
---|---|
dbo.ufnGetAccountingEndDate | Scalar function used in the uSalesOrderHeader trigger to set the starting account date. |
dbo.ufnGetAccountingStartDate | Scalar function used in the uSalesOrderHeader trigger to set the ending account date. |
dbo.ufnGetContactInformation | Table value function returning the first name, last name, job title and contact type for a given contact. |
dbo.ufnGetDocumentStatusText | Scalar function returning the text representation of the Status column in the Document table. |
dbo.ufnGetProductDealerPrice | Scalar function returning the dealer price for a given product on a particular order date. |
dbo.ufnGetProductListPrice | Scalar function returning the list price for a given product on a particular order date. |
dbo.ufnGetProductStandardCost | Scalar function returning the standard cost for a given product on a particular order date. |
dbo.ufnGetPurchaseOrderStatusText | Scalar function returning the text representation of the Status column in the PurchaseOrderHeader table. |
dbo.ufnGetSalesOrderStatusText | Scalar function returning the text representation of the Status column in the SalesOrderHeader table. |
dbo.ufnGetStock | Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID. |
dbo.ufnLeadingZeros | Scalar function used by the Sales.Customer table to help set the account number. |
User Defined Data Type | Description |
---|---|
dbo.AccountNumber | |
dbo.Flag | |
dbo.Name | |
dbo.NameStyle | |
dbo.OrderNumber | |
dbo.Phone |
No permissions defined