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