Example 2

To generate a SQL XML document using a for xml clause, enter:

select * from example_I18N_table for xml
---------------------------------------------------
<resultset xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">   
  <row>     
    <name>Arabic</name>            <uvcol>&#x622;&#x623;&#x624;&#x625;&#x626;</uvcol>    
  </row>    
  <row>        
    <name>Hebrew</name>            <uvcol>&#x5d2;&#x5d3;&#x5d4;&#x5d5;&#x5d6;</uvcol>    
  </row>    
  <row>        
   <name>Russian</name>           <uvcol>&#x410;&#x411;&#x412;&#x413;&#x414;</uvcol>    
  </row>}
</resultset>

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF