HumanResources.vJobCandidate (view) - Revision history

Bot at 22:16, 23 June 2010

2010-06-23T22:16:10Z

Bot at 22:09, 2 February 2010

2010-02-02T22:09:55Z

Bot at 21:57, 28 December 2009

2009-12-28T21:57:04Z

Bot at 06:00, 30 November 2009

2009-11-30T06:00:58Z

Bot at 05:39, 30 November 2009

2009-11-30T05:39:09Z

Bot at 05:25, 30 November 2009

2009-11-30T05:25:36Z

Bot at 22:59, 26 November 2009

2009-11-26T22:59:26Z

Bot at 22:28, 26 November 2009

2009-11-26T22:28:34Z

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

 CREATE VIEW [HumanResources].[vJobCan...

2009-01-03T12:36:34Z

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

New page

== wikibot ==

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

<pre>
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";
(/Resume/Name/Name.First)[1]', 'nvarchar(30)') AS [Name.First]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(/Resume/Name/Name.Middle)[1]', 'nvarchar(30)') AS [Name.Middle]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(/Resume/Name/Name.Last)[1]', 'nvarchar(30)') AS [Name.Last]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(/Resume/Name/Name.Suffix)[1]', 'nvarchar(30)') AS [Name.Suffix]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(/Resume/Skills)[1]', 'nvarchar(max)') AS [Skills]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(Address/Addr.Type)[1]', 'nvarchar(30)') AS [Addr.Type]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(Address/Addr.Location/Location/Loc.CountryRegion)[1]', 'nvarchar(100)') AS [Addr.Loc.CountryRegion]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(Address/Addr.Location/Location/Loc.State)[1]', 'nvarchar(100)') AS [Addr.Loc.State]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(Address/Addr.Location/Location/Loc.City)[1]', 'nvarchar(100)') AS [Addr.Loc.City]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(Address/Addr.PostalCode)[1]', 'nvarchar(20)') AS [Addr.PostalCode]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(/Resume/EMail)[1]', 'nvarchar(max)') AS [EMail]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(/Resume/WebSite)[1]', 'nvarchar(max)') AS [WebSite]
,jc.[ModifiedDate]
FROM [HumanResources].[JobCandidate] jc
CROSS APPLY jc.[Resume].nodes(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
/Resume') AS Resume(ref);
</pre>

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''View
 | HumanResources.vJobCandidate
@@ Line 8: / Line 8: @@
 | '''Description
 | Job candidate names and resumes.
 |}
 === Source ===
@@ Line 58: / Line 56: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Select
 | Table
 | [[HumanResources.JobCandidate_(table)|HumanResources.JobCandidate]]
-|-
+|- valign="top"
 | Schema
 | Schema

@@ Line 3: / Line 3: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |-
-| '''view
+| '''View
 | HumanResources.vJobCandidate
 |- valign="top"
@@ Line 11: / Line 11: @@
 |}
 <pre>
 CREATE VIEW [HumanResources].[vJobCandidate]
@@ Line 49: / Line 51: @@
 </pre>
+=== References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 60: / Line 62: @@
 | Table
 | [[HumanResources.JobCandidate_(table)|HumanResources.JobCandidate]]
 |}

@@ Line 52: / Line 52: @@
 | HumanResources.vJobCandidate
 |- valign="top"
 | '''Description
 | Job candidate names and resumes.
 |-
 |}

@@ Line 101: / Line 101: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | [[HumanResources.JobCandidate_(table)|HumanResources.JobCandidate]]
-| Table
 |-
 | Schema
 | Schema
 |}

@@ Line 51: / Line 51: @@
 | '''view
 | HumanResources.vJobCandidate
-|-
+|- valign="top"
 | '''Description
@@ Line 104: / Line 104: @@
 | '''Object Type
 | '''Dependency Type
-−
 |-
 | [[HumanResources.JobCandidate_(table)|HumanResources.JobCandidate]]
 | Table
 | Select
 |}

@@ Line 5: / Line 5: @@
 | '''view
 | HumanResources.vJobCandidate
 |-
 |}
@@ Line 45: / Line 48: @@
      /Resume') AS Resume(ref);
 </pre>
 == automatically generated ==