Production.vProductAndDescription (view) - Revision history

Bot at 22:17, 23 June 2010

2010-06-23T22:17:03Z

Bot at 22:10, 2 February 2010

2010-02-02T22:10:57Z

Bot at 21:57, 28 December 2009

2009-12-28T21:57:08Z

Bot at 06:01, 30 November 2009

2009-11-30T06:01:02Z

Bot at 05:39, 30 November 2009

2009-11-30T05:39:14Z

Bot at 05:25, 30 November 2009

2009-11-30T05:25:41Z

Bot at 22:59, 26 November 2009

2009-11-26T22:59:32Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''view | Production.vProductAndDescription |- |}

 CREATE VIEW [Production].[vProdu...

2009-01-03T12:36:38Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''view | Production.vProductAndDescription |- |} <pre> CREATE VIEW [Production].[vProdu...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''view
| Production.vProductAndDescription
|-
|}

<pre>
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];
</pre>

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''View
 | Production.vProductAndDescription
@@ Line 8: / Line 8: @@
 | '''Description
 | Product names and descriptions. Product descriptions are provided in multiple languages.
 |}
 === Source ===
@@ Line 40: / Line 38: @@
 | '''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

@@ Line 3: / Line 3: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |-
-| '''view
+| '''View
 | Production.vProductAndDescription
 |- valign="top"
@@ Line 11: / Line 11: @@
 |}
 <pre>
 CREATE VIEW [Production].[vProductAndDescription]
@@ Line 31: / Line 33: @@
 </pre>
+=== References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 57: / Line 59: @@
 | Table
 | [[Production.ProductModelProductDescriptionCulture_(table)|Production.ProductModelProductDescriptionCulture]]
 |}

@@ Line 34: / Line 34: @@
 | Production.vProductAndDescription
 |- valign="top"
 | '''Description
 | Product names and descriptions. Product descriptions are provided in multiple languages.
 |-
 |}

@@ Line 65: / Line 65: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | [[Production.Product_(table)|Production.Product]]
 | Table
 | Select
 |-
 | Select
 | Table
 | [[Production.ProductModelProductDescriptionCulture_(table)|Production.ProductModelProductDescriptionCulture]]
-| Table
 |-
 | Schema
 | Schema
 |}

@@ Line 27: / Line 27: @@
      ON pmx.[ProductDescriptionID] = pd.[ProductDescriptionID];
 </pre>
 == automatically generated ==
@@ Line 34: / Line 33: @@
 | '''view
 | Production.vProductAndDescription
-|-
+|- valign="top"
 | '''Description
@@ Line 69: / Line 68: @@
 | '''Object Type
 | '''Dependency Type
-−
 |-
 | [[Production.Product_(table)|Production.Product]]
@@ Line 86: / Line 85: @@
 | Table
 | Select
 |}

← Older revision		Revision as of 22:59, 26 November 2009
Line 27:		Line 27:
	ON pmx.[ProductDescriptionID] = pd.[ProductDescriptionID];		ON pmx.[ProductDescriptionID] = pd.[ProductDescriptionID];
	</pre>		</pre>
		+
		+	== automatically generated ==
		+
		+	{\| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
		+	\|-
		+	\| '''view
		+	\| Production.vProductAndDescription
		+	\|-
		+
		+	\| '''Description
		+	\| Product names and descriptions. Product descriptions are provided in multiple languages.
		+	\|-
		+
		+	\|}
		+
		+	<pre>
		+
		+	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];
		+	</pre>
		+
		+
		+	{\| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
		+	\|- style="background:silver"
		+	\| '''Referenced Object
		+	\| '''Object Type
		+	\| '''Dependency Type
		+
		+	\|-
		+	\| [[Production.Product_(table)\|Production.Product]]
		+	\| Table
		+	\| Select
		+	\|-
		+	\| [[Production.ProductDescription_(table)\|Production.ProductDescription]]
		+	\| Table
		+	\| Select
		+	\|-
		+	\| [[Production.ProductModel_(table)\|Production.ProductModel]]
		+	\| Table
		+	\| Select
		+	\|-
		+	\| [[Production.ProductModelProductDescriptionCulture_(table)\|Production.ProductModelProductDescriptionCulture]]
		+	\| Table
		+	\| Select
		+	\|}