Appendix A: The sample_docs Example Table

Publishers table representation

This code sample shows the XML representation of the publishers table in the Pubs 2 database, generated by the script in “sample_docs tables”.

set stringsize 16384
select text_doc from sample_docs
where name_doc='publishers'

text_doc

-------------------------------------------
<publishers
  xmlns:xsi="http://www.w3.org/2001/XMLSchema
  instance">   

<row> 
   <pub_id>0736</pub_id>
   <pub_name>New Age Books</pub_name>
   <city>Boston</city
   <state>MA</state>   
</row>   

<row>      
   <pub_id>0877</pub_id>
   <pub_name>Binnet & Hardley</pub_name>
   <city>Washington</city>
   <state>DC</state>   
</row>   

<row>      
   <pub_id>1389</pub_id>      
   <pub_name>Algodata Infosystems</pub_name>
   <city>Berkeley</city>
   <state>CA</state>   
</row>

</publishers>
(1 row affected)

View this book as PDF