for xml path(string)

原创于 2011-01-21 09:59:00 发布 · 534 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#path #xml #string #ui

数据库专栏收录该内容

3 篇文章

订阅专栏

for xml path(string)

1    select top 3 LoginId from Users for xml path ('')
     结果：    <LoginId>data1</LoginId>
                  <LoginId>data2</LoginId>
                  <LoginId>data3</LoginId>
2    select top 3 LoginId as [text()] from Users for xml path ('')
   结果：    data1data2data3
3    select top 3 LoginId as [text()] from Users for xml path ('ui')
     结果：    <ui>data1</ui>
                  <ui>data2</ui>
                  <ui>data3</ui>
4    select top 3 LoginId   from Users for xml path ('ui')
     结果：   <ui>
<LoginId>data1</LoginId>
                   </ui>
                   <ui>
                        <LoginId>data2</LoginId>
                   </ui>
                   <ui>
<LoginId>data3</LoginId>
                   </ui>