SQL与html转换

Question

试试这个：--DROP TABLE Tcreate table t(
ordinal int,
businessdate datetime,
boxskuid int,
rfsnumber varchar(20),
wfinstanceid varchar(20),
partnumber varchar(20)
)insert into t
select 1,GETDATE(),null,'1400835','39855196701','VPBBFF9D370AD' union all
select 1,GETDATE(),null,'1400835','39882068401','VPBBFF9D370AD'
goselect *
from T
for xml path('r')
/*
<r>
  <ordinal>1</ordinal>
  <businessdate>2014-02-21T18:12:01.977</businessdate>
  <rfsnumber>1400835</rfsnumber>
  <wfinstanceid>39855196701</wfinstanceid>
  <partnumber>VPBBFF9D370AD</partnumber>
</r>
<r>
  <ordinal>1</ordinal>
  <businessdate>2014-02-21T18:12:01.977</businessdate>
  <rfsnumber>1400835</rfsnumber>
  <wfinstanceid>39882068401</wfinstanceid>
  <partnumber>VPBBFF9D370AD</partnumber>
</r>
*/