USE pubs
GO
EXECUTE sp_makewebtask
@outputfile = 'C:\sql강의\sp_makewebtask.htm'
, @query = 'SELECT title, price FROM titles SELECT au_lname, au_fname FROM authors SELECT pub_id, pub_name FROM publishers SELECT au_lname, au_fname FROM authors'
, @templatefile = 'C:\sql강의\sp_makewebtask.tpl'
, @dbname = 'pubs'
, @rowcnt = 5,
@whentype = 9
GO
------------------- TPL 파일 설정----------------------------------
<H1>Books For Sale</H1><HR>
<P><TABLE BORDER>
<TR> <TH><I>Title</I></TH> <TH><B>Price</B></TH> </TR>
<%begindetail%>
<TR> <TD><I> <%insert_data_here%> </I> </TD>
<TD ALIGN=RIGHT><B> $<%insert_data_here%></B></TD> </TR>
<%enddetail%>
</TABLE>
<P><HR>
<%insert_data_here%>
<P><TABLE BORDER>
<TR> <TH ALIGN=CENTER>ID</TH> <TH ALIGN=LEFT><I>Publisher's Name</I></TH> </TR>
<%begindetail%>
<TR> <TD> <%insert_data_here%> </TD>
<TD ALIGN=LEFT><I> <%insert_data_here%></I></TD> </TR>
<%enddetail%>
</TABLE>
<HR>
<%insert_data_here%>
<A HREF = "http://www.microsoft.com">Microsoft</A>http://www.microsoft.com">Microsoft</A>
-------------------------- 결과 OUT 파일 ---------------------------
<H1>Books For Sale</H1>
<HR>
<TABLE BORDER>
<TR><TH><I>Title</I></TH> <TH><B>Price</B></TH> </TR>
<TR><TD><I> The Busy Executive's Database Guide </I></TD><TD ALIGN=RIGHT><B> $19.9900</B></TD> </TR>
<TR><TD><I> Cooking with Computers: Surreptitious Balance Sheets </I> </TD>
<TD ALIGN=RIGHT><B> $11.9500</B></TD></TR>
<TR><TD><I> You Can Combat Computer Stress! </I></TD>
<TD ALIGN=RIGHT><B> $2.9900</B></TD></TR>
<TR><TD><I> Straight Talk About Computers </I></TD>
<TD ALIGN=RIGHT><B> $19.9900</B></TD></TR>
<TR><TD><I> Silicon Valley Gastronomic Treats </I></TD>
<TD ALIGN=RIGHT><B> $19.9900</B></TD></TR>
</TABLE>
<P><TABLE BORDER=1>
<TR><TH ALIGN=LEFT>au_lname</TH><TH ALIGN=LEFT>au_fname</TH></TR>
<TR><TD><TT>Bennet</TT></TD><TD><TT>Abraham</TT></TD></TR>
<TR><TD><TT>Blotchet-Halls</TT></TD><TD><TT>Reginald</TT></TD></TR>
<TR><TD><TT>Carson</TT></TD><TD><TT>Cheryl</TT></TD></TR>
<TR><TD><TT>DeFrance</TT></TD><TD><TT>Michel</TT></TD></TR>
<TR><TD><TT>del Castillo</TT></TD><TD><TT>Innes</TT></TD></TR>
</TABLE>
<HR>
<TABLE BORDER>
<TR><TH ALIGN=CENTER>ID</TH> <TH ALIGN=LEFT><I>Publisher's Name</I></TH></TR>
<TR><TD> 0736 </TD><TD ALIGN=LEFT><I> New Moon Books</I></TD> </TR>
<TR><TD> 0877 </TD><TD ALIGN=LEFT><I> Binnet & Hardley</I></TD> </TR>
<TR><TD> 1389 </TD><TD ALIGN=LEFT><I> Algodata Infosystems</I></TD> </TR>
<TR><TD> 1622 </TD><TD ALIGN=LEFT><I> Five Lakes Publishing</I></TD> </TR>
<TR><TD> 1756 </TD><TD ALIGN=LEFT><I> Ramona Publishers</I></TD> </TR>
</TABLE>
<HR>
<TABLE BORDER=1>
<TR><TH ALIGN=LEFT>au_lname</TH><TH ALIGN=LEFT>au_fname</TH></TR>
<TR><TD><TT>Bennet</TT></TD><TD><TT>Abraham</TT></TD></TR>
<TR><TD><TT>Blotchet-Halls</TT></TD><TD><TT>Reginald</TT></TD></TR>
<TR><TD><TT>Carson</TT></TD><TD><TT>Cheryl</TT></TD></TR>
<TR><TD><TT>DeFrance</TT></TD><TD><TT>Michel</TT></TD></TR>
<TR><TD><TT>del Castillo</TT></TD><TD><TT>Innes</TT></TD></TR>
</TABLE>
---단 파일 저장소에 접근 권한과 파일 생성 권한이 있어야 한다.
DB와 웹 서버에가 한대에서 운영된다면 설정할 필요가 없겠지만..
