Bot at 22:16, 26 November 2009

2009-11-26T22:16:56Z

Bot: New page: == automatically generated == ms new parser (20091126 221728 AdvWorks2008-05-oltp.instawdb.sql) === Tables === Address (Person) [[Person.AddressType_(table)|...

2009-11-26T21:43:58Z

New page: == automatically generated == ms new parser (20091126 221728 AdvWorks2008-05-oltp.instawdb.sql) === Tables === Address (Person) [[Person.AddressType_(table)|...

New page

== automatically generated ==
ms new parser (20091126 221728 AdvWorks2008-05-oltp.instawdb.sql)

=== Tables ===

[[Person.Address_(table)|Address (Person)]]

[[Person.AddressType_(table)|AddressType (Person)]]

[[dbo.AWBuildVersion_(table)|AWBuildVersion (dbo)]]

[[Production.BillOfMaterials_(table)|BillOfMaterials (Production)]]

[[Person.Contact_(table)|Contact (Person)]]

[[Sales.ContactCreditCard_(table)|ContactCreditCard (Sales)]]

[[Person.ContactType_(table)|ContactType (Person)]]

[[Person.CountryRegion_(table)|CountryRegion (Person)]]

[[Sales.CountryRegionCurrency_(table)|CountryRegionCurrency (Sales)]]

[[Sales.CreditCard_(table)|CreditCard (Sales)]]

[[Production.Culture_(table)|Culture (Production)]]

[[Sales.Currency_(table)|Currency (Sales)]]

[[Sales.CurrencyRate_(table)|CurrencyRate (Sales)]]

[[Sales.Customer_(table)|Customer (Sales)]]

[[Sales.CustomerAddress_(table)|CustomerAddress (Sales)]]

[[dbo.DatabaseLog_(table)|DatabaseLog (dbo)]]

[[HumanResources.Department_(table)|Department (HumanResources)]]

[[Production.Document_(table)|Document (Production)]]

[[HumanResources.Employee_(table)|Employee (HumanResources)]]

[[HumanResources.EmployeeAddress_(table)|EmployeeAddress (HumanResources)]]

[[HumanResources.EmployeeDepartmentHistory_(table)|EmployeeDepartmentHistory (HumanResources)]]

[[HumanResources.EmployeePayHistory_(table)|EmployeePayHistory (HumanResources)]]

[[dbo.ErrorLog_(table)|ErrorLog (dbo)]]

[[Production.Illustration_(table)|Illustration (Production)]]

[[Sales.Individual_(table)|Individual (Sales)]]

[[HumanResources.JobCandidate_(table)|JobCandidate (HumanResources)]]

[[Production.Location_(table)|Location (Production)]]

[[Production.Product_(table)|Product (Production)]]

[[Production.ProductCategory_(table)|ProductCategory (Production)]]

[[Production.ProductCostHistory_(table)|ProductCostHistory (Production)]]

[[Production.ProductDescription_(table)|ProductDescription (Production)]]

[[Production.ProductDocument_(table)|ProductDocument (Production)]]

[[Production.ProductInventory_(table)|ProductInventory (Production)]]

[[Production.ProductListPriceHistory_(table)|ProductListPriceHistory (Production)]]

[[Production.ProductModel_(table)|ProductModel (Production)]]

[[Production.ProductModelIllustration_(table)|ProductModelIllustration (Production)]]

[[Production.ProductModelProductDescriptionCulture_(table)|ProductModelProductDescriptionCulture (Production)]]

[[Production.ProductPhoto_(table)|ProductPhoto (Production)]]

[[Production.ProductProductPhoto_(table)|ProductProductPhoto (Production)]]

[[Production.ProductReview_(table)|ProductReview (Production)]]

[[Production.ProductSubcategory_(table)|ProductSubcategory (Production)]]

[[Purchasing.ProductVendor_(table)|ProductVendor (Purchasing)]]

[[Purchasing.PurchaseOrderDetail_(table)|PurchaseOrderDetail (Purchasing)]]

[[Purchasing.PurchaseOrderHeader_(table)|PurchaseOrderHeader (Purchasing)]]

[[Sales.SalesOrderDetail_(table)|SalesOrderDetail (Sales)]]

[[Sales.SalesOrderHeader_(table)|SalesOrderHeader (Sales)]]

[[Sales.SalesOrderHeaderSalesReason_(table)|SalesOrderHeaderSalesReason (Sales)]]

[[Sales.SalesPerson_(table)|SalesPerson (Sales)]]

[[Sales.SalesPersonQuotaHistory_(table)|SalesPersonQuotaHistory (Sales)]]

[[Sales.SalesReason_(table)|SalesReason (Sales)]]

[[Sales.SalesTaxRate_(table)|SalesTaxRate (Sales)]]

[[Sales.SalesTerritory_(table)|SalesTerritory (Sales)]]

[[Sales.SalesTerritoryHistory_(table)|SalesTerritoryHistory (Sales)]]

[[Production.ScrapReason_(table)|ScrapReason (Production)]]

[[HumanResources.Shift_(table)|Shift (HumanResources)]]

[[Purchasing.ShipMethod_(table)|ShipMethod (Purchasing)]]

[[Sales.ShoppingCartItem_(table)|ShoppingCartItem (Sales)]]

[[Sales.SpecialOffer_(table)|SpecialOffer (Sales)]]

[[Sales.SpecialOfferProduct_(table)|SpecialOfferProduct (Sales)]]

[[Person.StateProvince_(table)|StateProvince (Person)]]

[[Sales.Store_(table)|Store (Sales)]]

[[Sales.StoreContact_(table)|StoreContact (Sales)]]

[[Production.TransactionHistory_(table)|TransactionHistory (Production)]]

[[Production.TransactionHistoryArchive_(table)|TransactionHistoryArchive (Production)]]

[[Production.UnitMeasure_(table)|UnitMeasure (Production)]]

[[Purchasing.Vendor_(table)|Vendor (Purchasing)]]

[[Purchasing.VendorAddress_(table)|VendorAddress (Purchasing)]]

[[Purchasing.VendorContact_(table)|VendorContact (Purchasing)]]

[[Production.WorkOrder_(table)|WorkOrder (Production)]]

[[Production.WorkOrderRouting_(table)|WorkOrderRouting (Production)]]

=== Views ===

[[Person.vAdditionalContactInfo_(view)|vAdditionalContactInfo (Person)]]

[[HumanResources.vEmployee_(view)|vEmployee (HumanResources)]]

[[HumanResources.vEmployeeDepartment_(view)|vEmployeeDepartment (HumanResources)]]

[[HumanResources.vEmployeeDepartmentHistory_(view)|vEmployeeDepartmentHistory (HumanResources)]]

[[Sales.vIndividualCustomer_(view)|vIndividualCustomer (Sales)]]

[[Sales.vIndividualDemographics_(view)|vIndividualDemographics (Sales)]]

[[HumanResources.vJobCandidate_(view)|vJobCandidate (HumanResources)]]

[[HumanResources.vJobCandidateEducation_(view)|vJobCandidateEducation (HumanResources)]]

[[HumanResources.vJobCandidateEmployment_(view)|vJobCandidateEmployment (HumanResources)]]

[[Production.vProductAndDescription_(view)|vProductAndDescription (Production)]]

[[Production.vProductModelCatalogDescription_(view)|vProductModelCatalogDescription (Production)]]

[[Production.vProductModelInstructions_(view)|vProductModelInstructions (Production)]]

[[Sales.vSalesPerson_(view)|vSalesPerson (Sales)]]

[[Sales.vSalesPersonSalesByFiscalYears_(view)|vSalesPersonSalesByFiscalYears (Sales)]]

[[Person.vStateProvinceCountryRegion_(view)|vStateProvinceCountryRegion (Person)]]

[[Sales.vStoreWithDemographics_(view)|vStoreWithDemographics (Sales)]]

[[Purchasing.vVendor_(view)|vVendor (Purchasing)]]

=== Procedures ===

[[dbo.uspGetBillOfMaterials_(procedure)|uspGetBillOfMaterials (dbo)]]

[[dbo.uspGetEmployeeManagers_(procedure)|uspGetEmployeeManagers (dbo)]]

[[dbo.uspGetManagerEmployees_(procedure)|uspGetManagerEmployees (dbo)]]

[[dbo.uspGetWhereUsedProductID_(procedure)|uspGetWhereUsedProductID (dbo)]]

[[dbo.uspLogError_(procedure)|uspLogError (dbo)]]

[[dbo.uspPrintError_(procedure)|uspPrintError (dbo)]]

[[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|uspUpdateEmployeeHireInfo (HumanResources)]]

[[HumanResources.uspUpdateEmployeeLogin_(procedure)|uspUpdateEmployeeLogin (HumanResources)]]

[[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|uspUpdateEmployeePersonalInfo (HumanResources)]]

=== Functions ===

[[dbo.ufnGetAccountingEndDate_(function)|ufnGetAccountingEndDate (dbo)]]

[[dbo.ufnGetAccountingStartDate_(function)|ufnGetAccountingStartDate (dbo)]]

[[dbo.ufnGetDocumentStatusText_(function)|ufnGetDocumentStatusText (dbo)]]

[[dbo.ufnGetProductDealerPrice_(function)|ufnGetProductDealerPrice (dbo)]]

[[dbo.ufnGetProductListPrice_(function)|ufnGetProductListPrice (dbo)]]

[[dbo.ufnGetProductStandardCost_(function)|ufnGetProductStandardCost (dbo)]]

[[dbo.ufnGetPurchaseOrderStatusText_(function)|ufnGetPurchaseOrderStatusText (dbo)]]

[[dbo.ufnGetSalesOrderStatusText_(function)|ufnGetSalesOrderStatusText (dbo)]]

[[dbo.ufnGetStock_(function)|ufnGetStock (dbo)]]

[[dbo.ufnLeadingZeros_(function)|ufnLeadingZeros (dbo)]]

[[dbo.ufnGetContactInformation_(function)|ufnGetContactInformation (dbo)]]

=== Schemas ===

[[HumanResources_(schema)|HumanResources]]

[[Person_(schema)|Person]]

[[Production_(schema)|Production]]

[[Purchasing_(schema)|Purchasing]]

[[Sales_(schema)|Sales]]

=== Types ===

[[.AccountNumber_(type)|AccountNumber ()]]

[[.Flag_(type)|Flag ()]]

[[.Name_(type)|Name ()]]

[[.NameStyle_(type)|NameStyle ()]]

[[.OrderNumber_(type)|OrderNumber ()]]

[[.Phone_(type)|Phone ()]]

=== XML Schema Collections ===

[[Person.AdditionalContactInfoSchemaCollection_(xml_schema_collection)|AdditionalContactInfoSchemaCollection (Person)]]

[[HumanResources.HRResumeSchemaCollection_(xml_schema_collection)|HRResumeSchemaCollection (HumanResources)]]

[[Sales.IndividualSurveySchemaCollection_(xml_schema_collection)|IndividualSurveySchemaCollection (Sales)]]

[[Production.ManuInstructionsSchemaCollection_(xml_schema_collection)|ManuInstructionsSchemaCollection (Production)]]

[[Production.ProductDescriptionSchemaCollection_(xml_schema_collection)|ProductDescriptionSchemaCollection (Production)]]

[[Sales.StoreSurveySchemaCollection_(xml_schema_collection)|StoreSurveySchemaCollection (Sales)]]

@@ Line 1: / Line 1: @@
 == automatically generated ==
-ms new parser (20091126 221728 AdvWorks2008-05-oltp.instawdb.sql)
+ms new parser (20091126 231028 AdvWorks2008-05-oltp.instawdb.sql)
 === Tables ===
@@ Line 238: / Line 238: @@
 === Types ===
-[[.AccountNumber_(type)|AccountNumber ()]]
+[[dbo.AccountNumber_(type)|AccountNumber (dbo)]]
-[[.Flag_(type)|Flag ()]]
+[[dbo.Flag_(type)|Flag (dbo)]]
-[[.Name_(type)|Name ()]]
+[[dbo.Name_(type)|Name (dbo)]]
-[[.NameStyle_(type)|NameStyle ()]]
+[[dbo.NameStyle_(type)|NameStyle (dbo)]]
-[[.OrderNumber_(type)|OrderNumber ()]]
+[[dbo.OrderNumber_(type)|OrderNumber (dbo)]]
-[[.Phone_(type)|Phone ()]]
+[[dbo.Phone_(type)|Phone (dbo)]]
 === XML Schema Collections ===

Database Objects AdventureWorks 2008-05 - Revision history

Bot at 22:16, 26 November 2009

Bot: New page: == automatically generated == ms new parser (20091126 221728 AdvWorks2008-05-oltp.instawdb.sql) === Tables === Address (Person) [[Person.AddressType_(table)|...