Microsoft® SQL Server 2012 Unleashed

Defining and Using xml Columns

You can add columns of type xml to any table by using a familiar Data Definition Language (DDL) syntax, with a few new twists. Much like their relational counterparts, xml columns, parameters, and variables may contain null or non-null values.

The following snippet shows the DDL used to create the table HumanResources.JobCandidate from AdventureWorks2012. The column you are concerned with is Resume:

Click here to view code image

CREATE TABLE [HumanResources].[JobCandidate](    [JobCandidateID] [int] IDENTITY(1,1) NOT NULL,    [EmployeeID] [int] NULL,    [Resume] [xml](CONTENT [HumanResources].[HRResumeSchemaCollection]) NULL,    [ModifiedDate] [datetime] NOT NULL    CONSTRAINT [DF_JobCandidate_ModifiedDate] DEFAULT ...