Object type: Data view

Displays the contact name and content from each element in the xml column AdditionalContactInfo for that person.

Properties 

Transactional	Uses cursors	Executes procedures	Dynamic content	Encrypted
No	No	No	No	No

Data Source Activity 

Accesses	Description
Person.Contact	Names of each employee, customer contact, and vendor contact.

Output Recordset 

Column	Description
ContactID
FirstName
MiddleName
LastName
TelephoneNumber
TelephoneSpecialInstructions
Street
City
StateProvince
PostalCode
CountryRegion
HomeAddressSpecialInstructions
EMailAddress
EMailSpecialInstructions
EMailTelephoneNumber
rowguid
ModifiedDate

Data source	Description
Person.Contact	Names of each employee, customer contact, and vendor contact.

Applies to

Views

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation