SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2008

Product Documentation

SQL Server 2008 Books Online

Database Engine

Development

Samples

AdventureWorks Sample Databases

AdventureWorks Sample OLTP Database

AdventureWorks Data Dictionary

Address Table (AdventureWorks)

AddressType Table (AdventureWorks)

AWBuildVersion Table (AdventureWorks)

BillOfMaterials Table (AdventureWorks)

Contact Table (AdventureWorks)

ContactCreditCard Table (AdventureWorks)

ContactType Table (AdventureWorks)

CountryRegionCurrency Table (AdventureWorks)

CountryRegion Table (AdventureWorks)

CreditCard Table (AdventureWorks)

Culture Table (AdventureWorks)

Currency Table (AdventureWorks)

CurrencyRate Table (AdventureWorks)

Customer Table (AdventureWorks)

CustomerAddress Table (AdventureWorks)

DatabaseLog Table (AdventureWorks)

Department Table (AdventureWorks)

Document Table (AdventureWorks)

Employee Table (AdventureWorks)

EmployeeAddress Table (AdventureWorks)

EmployeeDepartmentHistory Table (AdventureWorks)

EmployeePayHistory Table (AdventureWorks)

ErrorLog Table (AdventureWorks)

Illustration Table (AdventureWorks)

Individual Table (AdventureWorks)

JobCandidate Table (AdventureWorks)

Location Table (AdventureWorks)

Product Table (AdventureWorks)

ProductCategory Table (AdventureWorks)

ProductCostHistory Table (AdventureWorks)

ProductDescription Table (AdventureWorks)

ProductDocument Table (AdventureWorks)

ProductInventory Table (AdventureWorks)

ProductListPriceHistory Table (AdventureWorks)

ProductModel Table (AdventureWorks)

ProductModelIllustration Table (AdventureWorks)

ProductModelProductDescriptionCulture Table (AdventureWorks)

ProductPhoto Table (AdventureWorks)

ProductProductPhoto Table (AdventureWorks)

ProductReview Table (AdventureWorks)

ProductSubcategory Table (AdventureWorks)

ProductVendor Table (AdventureWorks)

PurchaseOrderDetail Table (AdventureWorks)

PurchaseOrderHeader Table (AdventureWorks)

SalesOrderDetail Table (AdventureWorks)

SalesOrderHeader Table (AdventureWorks)

SalesOrderHeaderSalesReason Table (AdventureWorks)

SalesPerson Table (AdventureWorks)

SalesPersonQuotaHistory Table (AdventureWorks)

SalesReason Table (AdventureWorks)

SalesTaxRate Table (AdventureWorks)

SalesTerritory Table (AdventureWorks)

SalesTerritoryHistory Table (AdventureWorks)

ScrapReason Table (AdventureWorks)

Shift Table (AdventureWorks)

ShipMethod Table (AdventureWorks)

ShoppingCartItem Table (AdventureWorks)

SpecialOffer Table (AdventureWorks)

SpecialOfferProduct Table (AdventureWorks)

StateProvince Table (AdventureWorks)

Store Table (AdventureWorks)

StoreContact Table (AdventureWorks)

TransactionHistory Table (AdventureWorks)

TransactionHistoryArchive Table (AdventureWorks)

UnitMeasure Table (AdventureWorks)

Vendor Table (AdventureWorks)

VendorAddress Table (AdventureWorks)

VendorContact Table (AdventureWorks)

WorkOrder Table (AdventureWorks)

WorkOrderRouting Table (AdventureWorks)

Minimize

This topic has not yet been rated - Rate this topic

SalesPersonQuotaHistory Table (AdventureWorks)

SQL Server 2008

SQL Server 2005

Contains the historical sales information for the sales representatives.

SalesPersonQuotaHistory Table Definition

The SalesPersonQuotaHistory table is contained in the Sales schema.

Column	Data type	Nullability	Description
SalesPersonID	int	Not null	Sales person identification number. Foreign key to SalesPerson.SalesPersonID.
QuotaDate	datetime	Not null	Sales quota date.
SalesQuota	money	Not null	Sales quota amount.
rowguid	uniqueidentifier	Not null	ROWGUIDCOL number uniquely identifying the row. Used to support a merge replication sample.
ModifiedDate	datetime	Not null	Date and time the row was last updated.

Reference

Employee Table (AdventureWorks)

SalesPerson Table (AdventureWorks)

SalesTerritory Table (AdventureWorks)

SalesTerritoryHistory Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.