Production.vProductAndDescription

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Production
Name	vProductAndDescription
Module	Products

Product names and descriptions. Product descriptions are provided in multiple languages.

Columns

	Name	Data type
1	ProductID	int
2	Name	nvarchar(50)
3	ProductModel	nvarchar(50)
4	CultureID	nchar(6)
5	Description	nvarchar(400)

Uses

Name
Production.vProductAndDescription
Production.Product
Production.ProductDescription
Production.ProductModel
Production.ProductModelProductDescriptionCulture

Script

CREATE VIEW [Production].[vProductAndDescription] WITH SCHEMABINDING AS -- View (indexed or standard) to display products and product descriptions by language. SELECT p.[ProductID] ,p.[Name] ,pm.[Name] AS [ProductModel] ,pmx.[CultureID] ,pd.[Description] FROM [Production].[Product] p INNER JOIN [Production].[ProductModel] pm ON p.[ProductModelID] = pm.[ProductModelID] INNER JOIN [Production].[ProductModelProductDescriptionCulture] pmx ON pm.[ProductModelID] = pmx.[ProductModelID] INNER JOIN [Production].[ProductDescription] pd ON pmx.[ProductDescriptionID] = pd.[ProductDescriptionID];

CREATE VIEW [Production].[vProductAndDescription] 
WITH SCHEMABINDING 
AS 
-- View (indexed or standard) to display products and product descriptions by language.
SELECT 
    p.[ProductID] 
    ,p.[Name] 
    ,pm.[Name] AS [ProductModel] 
    ,pmx.[CultureID] 
    ,pd.[Description] 
FROM [Production].[Product] p 
    INNER JOIN [Production].[ProductModel] pm 
    ON p.[ProductModelID] = pm.[ProductModelID] 
    INNER JOIN [Production].[ProductModelProductDescriptionCulture] pmx 
    ON pm.[ProductModelID] = pmx.[ProductModelID] 
    INNER JOIN [Production].[ProductDescription] pd 
    ON pmx.[ProductDescriptionID] = pd.[ProductDescriptionID];

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56