把数据库中表的内容转存为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