sqlserver html文档,[SQLServer]从SQL中的一个表中导出HTML文件表格

EXECUTE sp_makewebtask @outputfile = 'D:"alcatel"20030902"check.htm',

@query = 'Select * FROM Eiems_temporarydata..property', @templatefile = 'D:"alcatel"20030902"check.TPL',——check.tpl文件为模板文件

@dbname = 'Eiems_temporarydata', @rowcnt = 0, @whentype = 9 ,@lastupdated = 1

GO

******************************check.TPL*******************************

pelease check it when you finish!

body{font-size：9pt}

TH{FONT-SIZE: 12pt}

TD{ font-size: 12pt }

–>

check it!

---

Size	Date	Name	Exist	Remark	result