代码之家 › 专栏 › 技术社区 › Daniel

如何向以元素为中心的XML路径查询添加属性

for-xml-path tsql sql-server

4

Daniel · 技术社区 · 15 年前

declare @html varchar(max)

set @html = '<table cellpadding=0 cellspacing=0 border=0>'

set @html +=  
  cast(
    (select
      'Column1' as td, '',
      'Column2' as td, '',
      'Column3' as [td align=right] /* Would like to do something like this */
    for xml path('tr')) as varchar(max)
  )

set @html += '</table>'

1 回复 | 直到 15 年前

1

12

Joe Stefanelli 15 年前

<tr> 和 </tr> 标记到您的html字符串。这些都是给你的 for xml path('tr') </table> 到最后。

declare @html varchar(max)

set @html = '<table cellpadding=0 cellspacing=0 border=0>'

set @html +=  
  cast(
    (select
      'Column1' as td, '',
      'Column2' as td, '',
      'right' as [td/@align], 'Column3' as td, '' 
    for xml path('tr')) as varchar(max)
  )

set @html += '</table>'

select @html

输出为:

<table cellpadding=0 cellspacing=0 border=0><tr><td>Column1</td><td>Column2</td><td align="right">Column3</td></tr></table>