数据库名称：SQL server
数据库版本：2012
内容/问题描述：
在网络上找到由sql 组成html table的语法
select td = dbtable + '</td><td>' + cast( entities as varchar(30) ) +
'</td><td>' + cast( rows as varchar(30) )
from (
select dbtable = object_name( object_id ),
entities = count( distinct name ),
rows = count( * )
from sys.columns
group by object_name( object_id )
) as d
for xml path( 'tr' ), type
产生资料
[no name]
<tr><td>....</td></tr>
但需要用程式将此table资料html语法email出去，请问我要怎么改才能变成
[htmlbody]
<tr><td>....</td></tr>