USE pubs
GO
EXECUTE sp_makewebtask @outputfile = 'C:\MULTIPLE.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:\MULTIPLE.TPL',
@dbname = 'pubs', @rowcnt = 5, @whentype = 9
GO
--Se requiere esta plantilla
<HTML>
<HEAD>
<TITLE>SQL Server Multiple Queries with Template Web Sample</TITLE>
<BODY>
<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>Publishers 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%>
<P>
<A HREF = "http://www.microsoft.com">Microsoft</A><P>
<A HREF = "http://msdn.microsoft.com">MSDN</A><P>
</BODY>
</HTML>
No hay comentarios:
Publicar un comentario