Here you can search through the pages of this Namespace, their attachments and the files uploaded to the system.
Note: the results will only display the items you have permissions to read.
[...] wikibot adventureworks (mie60) Tables
Address (Person)
AddressType (Person)
AWBuildVersion (dbo)
BillOfMaterials (Production)
Contact (Person)
ContactCreditCard (Sales)
ContactType (Person)
CountryRegion (Person)
CountryRegionCurrency (Sales)
CreditCard (Sales)
Culture (Production)
Currency (Sales)
CurrencyRate (Sales)
Customer (Sales)
CustomerAddress (Sales)
DatabaseLog (dbo)
Department (HumanResources)
Document (Production)
Employee (HumanResources) [...]
[...] In process; 2 = Approved; 3 = Backordered; 4 = Rejected; 5 = Shipped; 6 = Cancelled OnlineOrderFlag dbo.Flag not null ((1)) 0 = Order placed by sales person. 1 = Order placed online by customer. SalesOrderNumber Unique sales order identification number. PurchaseOrderNumber dbo.OrderNumber null Customer purchase order number reference. AccountNumber dbo.AccountNumber null Financial accounting number reference. CustomerID int not null Customer identification number. Foreign key to Customer.CustomerID. [...]
[...] Nullable Default Description ContactID int not null Primary key for Contact records. NameStyle dbo.NameStyle not null ((0)) 0 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order. Title nvarchar(8) null A courtesy title. For example, Mr. or Ms. FirstName dbo.Name not null First name of the person. MiddleName dbo.Name null Middle name or middle initial of the person. LastName dbo.Name [...]
[...] Nullable Default Description VendorID int not null Primary key for Vendor records. AccountNumber dbo.AccountNumber not null Vendor account (identification) number. Name dbo.Name not null Company name. CreditRating tinyint not null 1 = Superior, 2 = Excellent, 3 = Above average, 4 = Average, 5 = Below average PreferredVendorStatus dbo.Flag not null ((1)) 0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the same product. ActiveFlag dbo.Flag [...]
[...] Type Nullable Default Description ProductID int not null Primary key for Product records. Name dbo.Name not null Name of the product. ProductNumber nvarchar(25) not null Unique product identification number. MakeFlag dbo.Flag not null ((1)) 0 = Product is purchased, 1 = Product is manufactured in-house. FinishedGoodsFlag dbo.Flag not null ((1)) 0 = Product is not a salable item. 1 = Product is salable. Color nvarchar(15) null Product color. SafetyStockLevel smallint not null Minimum inventory [...]
[...] [Purchasing].[PurchaseOrderHeader].[PurchaseOrderID] IN (SELECT inserted.[PurchaseOrderID] FROM inserted);
END TRY
BEGIN CATCH
EXECUTE [dbo].[uspPrintError];
-- Rollback any active or uncommittable transactions before
-- inserting information in the ErrorLog
IF @@TRANCOUNT > 0
BEGIN
ROLLBACK TRANSACTION;
END
EXECUTE [dbo].[uspLogError];
END CATCH;
END;
Trigger uPurchaseOrderDetail
CREATE TRIGGER [Purchasing].[uPurchaseOrderDetail] ON [Purchasing].[PurchaseOrderDetail]
AFTER UPDATE AS
BEGIN
DECLARE @Count int;
SET [...]
[...] ,GETDATE()
,inserted.[OrderQty]
,0
FROM inserted;
END TRY
BEGIN CATCH
EXECUTE [dbo].[uspPrintError];
-- Rollback any active or uncommittable transactions before
-- inserting information in the ErrorLog
IF @@TRANCOUNT > 0
BEGIN
ROLLBACK TRANSACTION;
END
EXECUTE [dbo].[uspLogError];
END CATCH;
END;
Trigger uWorkOrder
CREATE TRIGGER [Production].[uWorkOrder] ON [Production].[WorkOrder]
AFTER UPDATE AS
BEGIN
DECLARE @Count int;
SET @Count = @@ROWCOUNT;
IF [...]
wikibot
Procedure dbo.uspLogError Description 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. Source
-- 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. This should be executed from within the scope
-- of a CATCH block otherwise it will [...]
[...] Default Description CustomerID int not null Primary key. Foreign key to Customer.CustomerID. Name dbo.Name not null Name of the store. SalesPersonID int null ID of the sales person assigned to the customer. Foreign key to SalesPerson.SalesPersonID. Demographics xml null Demographic informationg about the store such as the number of employees, annual sales and store type. rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. ModifiedDate datetime not null (getdate()) Date [...]
[...] null M = Male, F = Female HireDate datetime not null Employee hired on this date. SalariedFlag dbo.Flag not null ((1)) Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining. VacationHours smallint not null ((0)) Number of available vacation hours. SickLeaveHours smallint not null ((0)) Number of available sick leave hours. CurrentFlag dbo.Flag not null ((1)) 0 = Inactive, 1 = Active rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying [...]
wikibot
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. Source
-- 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 [...]
wikibot
Table dbo.ErrorLog Description 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. Columns Column Data Type Nullable Default Description ErrorLogID int not null Primary key for ErrorLog records. ErrorTime datetime not null (getdate()) The date and time at which the error occurred. UserName sysname not null [...]
wikibot
Function dbo.ufnGetStock Description Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID. Source
CREATE FUNCTION [dbo].[ufnGetStock](@ProductID [...]
wikibot
Function dbo.ufnLeadingZeros Description Scalar function used by the Sales.Customer table to help set the account number. Source
CREATE FUNCTION [dbo].[ufnLeadingZeros](
[...]
wikibot
Function dbo.ufnGetSalesOrderStatusText Description Scalar function returning the text representation of the Status column in the SalesOrderHeader table. Source
CREATE FUNCTION [dbo].[ufnGetSalesOrderStatusText](@Status [...]
wikibot
Function dbo.ufnGetPurchaseOrderStatusText Description Scalar function returning the text representation of the Status column in the PurchaseOrderHeader table. Source
CREATE FUNCTION [dbo].[ufnGetPurchaseOrderStatusText](@Status [...]
wikibot
Procedure dbo.uspGetBillOfMaterials Description Stored procedure using a recursive query to return a multi-level bill of material for the specified ProductID. Source
CREATE PROCEDURE [dbo].[uspGetBillOfMaterials]
[...]
wikibot
Function dbo.ufnGetDocumentStatusText Description Scalar function returning the text representation of the Status column in the Document table. Source
CREATE FUNCTION [dbo].[ufnGetDocumentStatusText](@Status [...]
[...] standard country or region code. Foreign key to CountryRegion.CountryRegionCode. IsOnlyStateProvinceFlag dbo.Flag not null ((1)) 0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode. Name dbo.Name not null State or province description. TerritoryID int not null ID of the territory in which the state or province is located. Foreign key to SalesTerritory.SalesTerritoryID. rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. [...]
wikibot
Procedure dbo.uspGetWhereUsedProductID Description Stored procedure using a recursive query to return all components or assemblies that directly or indirectly use the specified ProductID. Source
CREATE PROCEDURE [dbo].[uspGetWhereUsedProductID]
[...]
wikibot
Procedure dbo.uspGetEmployeeManagers Description Stored procedure using a recursive query to return the direct and indirect managers of the specified employee. Source
CREATE PROCEDURE [dbo].[uspGetEmployeeManagers]
[...]
wikibot
Procedure dbo.uspGetManagerEmployees Description Stored procedure using a recursive query to return the direct and indirect employees of the specified manager. Source
CREATE PROCEDURE [dbo].[uspGetManagerEmployees]
[...]
wikibot
Function dbo.ufnGetProductStandardCost Description Scalar function returning the standard cost for a given product on a particular order date. Source
CREATE FUNCTION [dbo].[ufnGetProductStandardCost](@ProductID [...]
wikibot
type dbo.Flag Source
CREATE TYPE dbo.Flag [...]
wikibot
type dbo.Name Source
CREATE TYPE dbo.[Name] [...]
wikibot
type dbo.NameStyle Source
CREATE TYPE dbo.NameStyle [...]
wikibot
Table dbo.AWBuildVersion Description Current version number of the AdventureWorks sample database. Columns Column Data Type Nullable Default Description SystemInformationID tinyint not null Primary key for AWBuildVersion records. Database Version nvarchar(25) not null Version number of the database in 9.yy.mm.dd.00 format. VersionDate datetime not null Date and time the record was last updated. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_AWBuildVersion_SystemInformationID [...]
[...] [Sales].[SalesOrderHeader].[CustomerID] = [Sales].[Individual].[CustomerID];
END TRY
BEGIN CATCH
EXECUTE [dbo].[uspPrintError];
-- Rollback any active or uncommittable transactions before
-- inserting information in the ErrorLog
IF @@TRANCOUNT > 0
BEGIN
ROLLBACK TRANSACTION;
END
EXECUTE [dbo].[uspLogError];
END CATCH;
END;
References Dependency Type Object Type Referenced Object Child Type Child Object Schema Schema Sales Insert Table Production.TransactionHistory Trigger iduSalesOrderDetail [...]
[...] (SELECT inserted.[PurchaseOrderID] FROM inserted);
END;
END TRY
BEGIN CATCH
EXECUTE [dbo].[uspPrintError];
-- Rollback any active or uncommittable transactions before
-- inserting information in the ErrorLog
IF @@TRANCOUNT > 0
BEGIN
ROLLBACK TRANSACTION;
END
EXECUTE [dbo].[uspLogError];
END CATCH;
END;
References Dependency Type Object Type Referenced Object Child Type Child Object Schema Schema Purchasing Update Table Purchasing.PurchaseOrderHeader Trigger uPurchaseOrderHeader [...]
wikibot
type dbo.AccountNumber Source
CREATE TYPE dbo.AccountNumber [...]