Production vProductAndDescription (view)

Modified on 2011/08/27 11:18 by wikibot Categorized as Uncategorized

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''View'''
| Production.vProductAndDescription
|- valign="top"
| '''Description'''
| Product names and descriptions. Product descriptions are provided in multiple languages.
|}

=== Source ===
{{{{<nowiki>
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];
</nowiki>}}}}

=== References ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Dependency Type'''
| '''Object Type'''
| '''Referenced Object'''

|- valign="top"
| Select
| Table
| [[Production Product (table)|Production.Product]]

|- valign="top"
| Select
| Table
| [[Production ProductDescription (table)|Production.ProductDescription]]

|- valign="top"
| Select
| Table
| [[Production ProductModel (table)|Production.ProductModel]]

|- valign="top"
| Select
| Table
| [[Production ProductModelProductDescriptionCulture (table)|Production.ProductModelProductDescriptionCulture]]

|- valign="top"
| Schema
| Schema
| [[Production (schema)|Production]]

|}

devio dbscript ScrewTurn Wiki

Navigation¶

Production vProductAndDescription (view)