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*******************************
<HTML> <HEAD> <TITLE>pelease check it when you finish!</TITLE> <style type="text/css">
body{font-size:9pt} TH{FONT-SIZE: 12pt} TD{ font-size: 12pt }
-->
</style> <BODY text="#ffffff" BGCOLOR="#FFF5EE"> <center> <H1><font color="000000">check it!</font></H1> <HR>
<P> <H2> <TABLE BORDER="1" cellpadding="0" cellspacing="0"bgcolor="#436EEE"> <TR> <TH><B>Size</B></TH> <TH><B>Date</B></TH> <TH><B>Name</B></TH> <TH><B>Exist</B></TH> <TH><B>Remark</B></TH> <TH><B>result</B></TH> </TR> <%begindetail%> <TR> <TD> <%insert_data_here%> </TD> <TD ALIGN=RIGHT><%insert_data_here%></TD> <TD ALIGN=RIGHT><%insert_data_here%></TD> <TD ALIGN=RIGHT><%insert_data_here%></TD> <TD ALIGN=RIGHT><%insert_data_here%></TD> <TD ALIGN=RIGHT><%insert_data_here%></TD> </TR> <%enddetail%> </TABLE> </center> </H2> </BODY> </HTML>
关注此文的读者还看过:
- 2010-4-1 18:12:45 预防非法表D99_Tmp,kill_kk的建立
- 2008-4-23 15:53:39 SQL Server数据库超级管理员账号防护知识
- 2008-4-11 21:37:35 SQL Server 2005数据库镜像配置脚本示例
- 2008-4-4 9:12:54 讲解如何实现互联网上数据库的安全
- 2008-4-1 11:07:24 SQL 2005数据库转到SQL 2000的步骤讲解
- 2008-3-31 12:39:45 SQL Server自动生成日期加数字的序列号
- 2008-3-31 12:39:07 SQL Server 2000的数据库容量究竟是多大
- 2008-3-18 18:01:49 SQL Server 2005数据库的同义词Bug 讲解
|