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
Schema [...]
[...] Description Contains objects related to products, inventory, and manufacturing. Source
CREATE SCHEMA Production AUTHORIZATION dbo
Dependencies Reference Type Object Type Referencing Object Schema Table Production.BillOfMaterials Schema Table Production.Culture Schema Table Production.Document Schema Table Production.Illustration Schema Table Production.Location Schema [...]
wikibot
Schema Sales Description Contains objects related to customers, sales orders, and sales territories. Source
CREATE SCHEMA Sales AUTHORIZATION dbo
Dependencies Reference Type Object Type Referencing Object Schema Table Sales.ContactCreditCard Schema Table Sales.CountryRegionCurrency Schema [...]
wikibot
Table HumanResources.Employee Description Employee information such as salary, department, and title. Columns Column Data Type Nullable Default Description EmployeeID int not null Primary key for Employee records. NationalIDNumber nvarchar(15) not null Unique national identification number such as a social security number. ContactID int not null Identifies the employee in the Contact table. Foreign key to Contact.ContactID. LoginID nvarchar(256) not null Network login. ManagerID int null Manager to whom the employee is assigned. [...]
[...] (Sales)
Customer (Sales)
CustomerAddress (Sales)
DatabaseLog (dbo)
Department (HumanResources)
Document (Production)
Employee (HumanResources)
EmployeeAddress (HumanResources)
EmployeeDepartmentHistory (HumanResources)
EmployeePayHistory (HumanResources)
ErrorLog (dbo)
Illustration (Production)
Individual (Sales)
JobCandidate (HumanResources)
Location (Production) [...]
wikibot
XML Schema Collection HumanResources.HRResumeSchemaCollection Description Collection of XML schemas for the Resume column in the HumanResources.JobCandidate table. Source
[...]
wikibot
Schema Person Description Contains objects related to names and addresses of customers, vendors, and employees Source
CREATE SCHEMA Person AUTHORIZATION dbo
Dependencies Reference Type Object Type Referencing Object [...]
wikibot
View HumanResources.vEmployeeDepartmentHistory Description Returns employee name and current and previous departments. Source
CREATE VIEW [HumanResources].[vEmployeeDepartmentHistory]
AS
SELECT
e.[EmployeeID]
,c.[Title]
,c.[FirstName]
,c.[MiddleName]
,c.[LastName]
,c.[Suffix]
,s.[Name] AS [Shift]
,d.[Name] AS [Department]
,d.[GroupName]
,edh.[StartDate]
,edh.[EndDate]
FROM [HumanResources].[Employee] e
INNER JOIN [Person].[Contact] c
[...]
wikibot
Table HumanResources.JobCandidate Description Résumés submitted to Human Resources by job applicants. Columns Column Data Type Nullable Default Description JobCandidateID int not null Primary key for JobCandidate records. EmployeeID int null Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID. Resume xml null Résumé in XML format. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_JobCandidate_JobCandidateID JobCandidateID [...]
wikibot
View HumanResources.vEmployeeDepartment Description Returns employee name, title, and current department. Source
CREATE VIEW [HumanResources].[vEmployeeDepartment]
AS
SELECT
e.[EmployeeID]
,c.[Title]
,c.[FirstName]
,c.[MiddleName]
,c.[LastName]
,c.[Suffix]
,e.[Title] AS [JobTitle]
,d.[Name] AS [Department]
,d.[GroupName]
,edh.[StartDate]
FROM [HumanResources].[Employee] e
INNER JOIN [Person].[Contact] c
ON c.[ContactID] = e.[ContactID]
[...]
[...] Purchasing Description Contains objects related to vendors and purchase orders. Source
CREATE SCHEMA Purchasing AUTHORIZATION dbo
Dependencies Reference Type Object Type Referencing Object Schema Table Purchasing.ProductVendor Schema [...]
wikibot
Procedure HumanResources.uspUpdateEmployeeHireInfo Description Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters. Source
CREATE PROCEDURE [HumanResources].[uspUpdateEmployeeHireInfo]
@EmployeeID [int],
@Title [nvarchar](50),
@HireDate [datetime],
@RateChangeDate [datetime],
@Rate [money],
@PayFrequency [tinyint],
@CurrentFlag [dbo].[Flag]
WITH EXECUTE AS CALLER
AS
BEGIN
SET NOCOUNT ON;
BEGIN TRY
[...]
wikibot
View HumanResources.vEmployee Description Employee names and addresses. Source
CREATE VIEW [HumanResources].[vEmployee]
AS
SELECT
e.[EmployeeID]
,c.[Title]
,c.[FirstName]
,c.[MiddleName]
,c.[LastName]
,c.[Suffix]
,e.[Title] AS [JobTitle]
,c.[Phone]
,c.[EmailAddress]
,c.[EmailPromotion]
,a.[AddressLine1]
,a.[AddressLine2]
,a.[City]
,sp.[Name] AS [StateProvinceName]
,a.[PostalCode]
,cr.[Name] AS [CountryRegionName]
,c.[AdditionalContactInfo]
FROM [HumanResources].[Employee] [...]
wikibot
Table HumanResources.EmployeeDepartmentHistory Description Employee department transfers. Columns Column Data Type Nullable Default Description EmployeeID int not null Employee identification number. Foreign key to Employee.EmployeeID. DepartmentID smallint not null Department in which the employee worked including currently. Foreign key to Department.DepartmentID. ShiftID tinyint not null Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID. StartDate datetime not null Date the employee started work in [...]
wikibot
View HumanResources.vJobCandidateEducation Description Displays the content from each education related element in the xml column Resume in the HumanResources.JobCandidate table. The content has been localized into French, Simplified Chinese and Thai. Some data may not display correctly unless supplemental language support is installed. Source
CREATE VIEW [HumanResources].[vJobCandidateEducation]
AS
SELECT
jc.[JobCandidateID]
,[Education].ref.value(N'declare default element namespace [...]
wikibot
View HumanResources.vJobCandidateEmployment Description Displays the content from each employement history related element in the xml column Resume in the HumanResources.JobCandidate table. The content has been localized into French, Simplified Chinese and Thai. Some data may not display correctly unless supplemental language support is installed. Source
CREATE VIEW [HumanResources].[vJobCandidateEmployment]
AS
SELECT
jc.[JobCandidateID]
,CONVERT(datetime, REPLACE([Employment].ref.value(N'declare [...]
wikibot
XML Schema Collection Production.ProductDescriptionSchemaCollection Description Collection of XML schemas for the CatalogDescription column in the Production.ProductModel table. Source
[...]
wikibot
View HumanResources.vJobCandidate Description Job candidate names and resumes. Source
CREATE VIEW [HumanResources].[vJobCandidate]
AS
SELECT
jc.[JobCandidateID]
,jc.[EmployeeID]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(/Resume/Name/Name.Prefix)[1]', 'nvarchar(30)') AS [Name.Prefix]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
[...]
wikibot
XML Schema Collection Person.AdditionalContactInfoSchemaCollection Description Collection of XML schemas for the AdditionalContactInfo column in the Person.Contact table. Source [...]
wikibot
XML Schema Collection Sales.StoreSurveySchemaCollection Description Collection of XML schemas for the Demographics column in the Sales.Store table. Source
[...]
wikibot
XML Schema Collection Production.ManuInstructionsSchemaCollection Description Collection of XML schemas for the Instructions column in the Production.ProductModel table. Source
[...]
wikibot
XML Schema Collection Sales.IndividualSurveySchemaCollection Description Collection of XML schemas for the Demographics column in the Sales.Individual table. Source
[...]
wikibot
Procedure HumanResources.uspUpdateEmployeePersonalInfo Description Updates the Employee table with the values specified in the input parameters for the given EmployeeID. Source
CREATE PROCEDURE [HumanResources].[uspUpdateEmployeePersonalInfo]
@EmployeeID [int],
@NationalIDNumber [nvarchar](15),
@BirthDate [datetime],
@MaritalStatus [nchar](1),
@Gender [nchar](1)
WITH EXECUTE AS CALLER
AS
BEGIN
SET NOCOUNT ON;
BEGIN TRY
UPDATE [HumanResources].[Employee] [...]
wikibot
Procedure HumanResources.uspUpdateEmployeeLogin Description Updates the Employee table with the values specified in the input parameters for the given EmployeeID. Source
CREATE PROCEDURE [HumanResources].[uspUpdateEmployeeLogin]
@EmployeeID [int],
@ManagerID [int],
@LoginID [nvarchar](256),
@Title [nvarchar](50),
@HireDate [datetime],
@CurrentFlag [dbo].[Flag]
WITH EXECUTE AS CALLER
AS
BEGIN
SET NOCOUNT ON;
BEGIN TRY
UPDATE [HumanResources].[Employee]
[...]
wikibot
Table HumanResources.Shift Description Work shift lookup table. Columns Column Data Type Nullable Default Description ShiftID tinyint not null Primary key for Shift records. Name dbo.Name not null Shift description. StartTime datetime not null Shift start time. EndTime datetime not null Shift end time. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_Shift_ShiftID ShiftID Indexes Index Type Columns AK_Shift_Name Unique Name AK_Shift_StartTime_EndTime [...]
wikibot
Table HumanResources.Department Description Lookup table containing the departments within the Adventure Works Cycles company. Columns Column Data Type Nullable Default Description DepartmentID smallint not null Primary key for Department records. Name dbo.Name not null Name of the department. GroupName dbo.Name not null Name of the group to which the department belongs. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_Department_DepartmentID DepartmentID [...]
wikibot
Table HumanResources.EmployeeAddress Description Cross-reference table mapping employees to their address(es). Columns Column Data Type Nullable Default Description EmployeeID int not null Primary key. Foreign key to Employee.EmployeeID. AddressID int not null Primary key. Foreign key to Address.AddressID. rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary [...]
[...] Tables Detail Table Column Referencing Column Sales.ContactCreditCard ContactID ContactID HumanResources.Employee ContactID ContactID Sales.Individual ContactID ContactID Sales.SalesOrderHeader ContactID ContactID Sales.StoreContact ContactID ContactID Purchasing.VendorContact ContactID ContactID References Dependency Type Object Type Referenced Object Data Type Type dbo.Name Data Type Type dbo.NameStyle Data Type Type dbo.Phone Schema Schema Person Data Type XML
wikibot
Table HumanResources.EmployeePayHistory Description Employee pay history. Columns Column Data Type Nullable Default Description EmployeeID int not null Employee identification number. Foreign key to Employee.EmployeeID. RateChangeDate datetime not null Date the change in pay is effective Rate money not null Salary hourly rate. PayFrequency tinyint not null 1 = Salary received monthly, 2 = Salary received biweekly ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns [...]
[...] ,s.[SalesQuota]
,s.[SalesYTD]
,s.[SalesLastYear]
FROM [Sales].[SalesPerson] s
INNER JOIN [HumanResources].[Employee] e
ON e.[EmployeeID] = s.[SalesPersonID]
LEFT OUTER JOIN [Sales].[SalesTerritory] st
ON st.[TerritoryID] = s.[TerritoryID]
INNER JOIN [Person].[Contact] c
ON c.[ContactID] = e.[ContactID]
INNER JOIN [HumanResources].[EmployeeAddress] ea
ON e.[EmployeeID] = ea.[EmployeeID]
INNER JOIN [Person].[Address] a
ON ea.[AddressID] = a.[AddressID]
INNER JOIN [Person].[StateProvince] sp
[...]