LISTING 2: Select and Store Author’s State of Residence and Author Object

INSERT INTO AuthorObjects(State, Object)
SELECT STATE, XML
FROM OpenXML(@docHandle,’//author’)
     WITH (STATE, varchar(2), ‘residence/state’,
           XML, text, ‘@mp:xmltext’)