AdventureWorks
| View Name: | Person.vAdditionalContactInfo |
| Description: | Displays the contact name and content from each element in the xml column AdditionalContactInfo for that person. |
| Field | Type | Nulls? |
|---|---|---|
| ContactID | int | No |
| FirstName | nvarchar (50) | No |
| MiddleName | nvarchar (50) | Yes |
| LastName | nvarchar (50) | No |
| TelephoneNumber | nvarchar (50) | Yes |
| TelephoneSpecialInstructions | nvarchar (MAX) | Yes |
| Street | nvarchar (50) | Yes |
| City | nvarchar (50) | Yes |
| StateProvince | nvarchar (50) | Yes |
| PostalCode | nvarchar (50) | Yes |
| CountryRegion | nvarchar (50) | Yes |
| HomeAddressSpecialInstructions | nvarchar (MAX) | Yes |
| EMailAddress | nvarchar (128) | Yes |
| EMailSpecialInstructions | nvarchar (MAX) | Yes |
| EMailTelephoneNumber | nvarchar (50) | Yes |
| rowguid | uniqueidentifier | No |
| ModifiedDate | datetime | No |