|
|
Line 1: |
Line 1: |
− | == wikibot ==
| |
| | | |
− | == adventureworks (mie54) ==
| |
− | === 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 ===
| |
− |
| |
− | [[dbo.AccountNumber_(type)|AccountNumber (dbo)]]
| |
− |
| |
− | [[dbo.Flag_(type)|Flag (dbo)]]
| |
− |
| |
− | [[dbo.Name_(type)|Name (dbo)]]
| |
− |
| |
− | [[dbo.NameStyle_(type)|NameStyle (dbo)]]
| |
− |
| |
− | [[dbo.OrderNumber_(type)|OrderNumber (dbo)]]
| |
− |
| |
− | [[dbo.Phone_(type)|Phone (dbo)]]
| |
− |
| |
− | === 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)]]
| |