把数据库中表的内容转存为XML文件

把数据库中表的内容转存为XML字符串
( 1)
       SELECT  TOP  2
         *
FROM    dbo.ProductProperty
FOR     XML PATH

<row >
   <ProductPropertyID > 1 </ProductPropertyID >
   <Code >BU93 </Code >
   <Weight > 0.053500 </Weight >
   <DistributeAreaID > 3 </DistributeAreaID >
   <IsThirdStock > 0 </IsThirdStock >
   <CreateUser >system </CreateUser >
   <CreateDate > 2013 - 05 -15T10: 55: 12.737 </CreateDate >
   <LastUpdUser >system </LastUpdUser >
   <LastUpdDate > 2013 - 05 -15T17: 31: 49.380 </LastUpdDate >
</row >
<row >
   <ProductPropertyID > 2 </ProductPropertyID >
   <Code >BU95 </Code >
   <Weight > 0.073500 </Weight >
   <DistributeAreaID > 3 </DistributeAreaID >
   <IsThirdStock > 0 </IsThirdStock >
   <CreateUser >system </CreateUser >
   <CreateDate > 2013 - 05 -15T10: 55: 12.737 </CreateDate >
   <LastUpdUser >system </LastUpdUser >
   <LastUpdDate > 2013 - 05 -15T10: 55: 12.737 </LastUpdDate >
</row >

( 2)            
SELECT  TOP  2
         *
FROM    dbo.ProductProperty
FOR     XML AUTO ,
            ROOT( ' root ') 
           
返回
<root >
   <dbo.ProductProperty ProductPropertyID =" 1" Code ="BU93" Weight =" 0.053500" DistributeAreaID =" 3" IsThirdStock =" 0" CreateUser ="system" CreateDate =" 2013 - 05 -15T10: 55: 12.737" LastUpdUser ="system" LastUpdDate =" 2013 - 05 -15T17: 31: 49.380"  />
   <dbo.ProductProperty ProductPropertyID =" 2" Code ="BU95" Weight =" 0.073500" DistributeAreaID =" 3" IsThirdStock =" 0" CreateUser ="system" CreateDate =" 2013 - 05 -15T10: 55: 12.737" LastUpdUser ="system" LastUpdDate =" 2013 - 05 -15T10: 55: 12.737"  />
</root >

( 3)           
SELECT  TOP  2
         *
FROM    dbo.ProductProperty
FOR     XML AUTO ,
            ROOT( ' root ') ,
            ELEMENTS
            
返回:
<root >
   <dbo.ProductProperty >
     <ProductPropertyID > 1 </ProductPropertyID >
     <Code >BU93 </Code >
     <Weight > 0.053500 </Weight >
     <DistributeAreaID > 3 </DistributeAreaID >
     <IsThirdStock > 0 </IsThirdStock >
     <CreateUser >system </CreateUser >
     <CreateDate > 2013 - 05 -15T10: 55: 12.737 </CreateDate >
     <LastUpdUser >system </LastUpdUser >
     <LastUpdDate > 2013 - 05 -15T17: 31: 49.380 </LastUpdDate >
   </dbo.ProductProperty >
   <dbo.ProductProperty >
     <ProductPropertyID > 2 </ProductPropertyID >
     <Code >BU95 </Code >
     <Weight > 0.073500 </Weight >
     <DistributeAreaID > 3 </DistributeAreaID >
     <IsThirdStock > 0 </IsThirdStock >
     <CreateUser >system </CreateUser >
     <CreateDate > 2013 - 05 -15T10: 55: 12.737 </CreateDate >
     <LastUpdUser >system </LastUpdUser >
     <LastUpdDate > 2013 - 05 -15T10: 55: 12.737 </LastUpdDate >
   </dbo.ProductProperty >
</root >

View Code

转载于:https://www.cnblogs.com/51net/p/3368311.html