LISTING 2: Schema for Composite Table

CREATE TABLE [dbo].[Composite] (
	[xml] [ntext]
)

INSERT INTO COMPOSITE (xml)
VALUES ('<authors><author name="Smith Meander" state="KS"/>
<author name="Panteley Sylvia" state="MD"/>
<author name="Ringer Anne" state="UT"/>
<author name="Ringer Albert" state="UT"/></authors>')