Creates a task that produces an HTML document containing data returned by executed queries.
Note All Web jobs are categorized as Web Assistant in the Job Categories dialog box in SQL Server Enterprise Manager. For more information, see Defining Jobs.
sp_makewebtask [@outputfile =] 'outputfile', [@query =] 'query'
[, [@fixedfont =] fixedfont]
[, [@bold =] bold]
[, [@italic =] italic]
[, [@colheaders =] colheaders]
[, [@lastupdated =] lastupdated]
[, [@HTMLHeader =] HTMLHeader]
[, [@username =] username]
[, [@dbname =] dbname]
[, [@templatefile =] 'templatefile']
[, [@webpagetitle =] 'webpagetitle']
[, [@resultstitle =] 'resultstitle']
[
[, [@URL =] 'URL', [@reftext =] 'reftext']
| [, [@table_urls =] table_urls, [@url_query =] 'url_query']
]
[, [@whentype =] whentype]
[, [@targetdate =] targetdate]
[, [@targettime =] targettime]
[, [@dayflags =] dayflags]
[, [@numunits =] numunits]
[, [@unittype =] unittype]
[, [@procname =] procname ]
[, [@maketask =] maketask]
[, [@rowcnt =] rowcnt]
[, [@tabborder =] tabborder]
[, [@singlerow =] singlerow]
[, [@blobfmt =] blobfmt]
[, [@nrowsperpage =] n]
[, [@datachg =] table_column_list]
[, [@charset =] characterset]
[, [@codepage =] codepage]
| Value | HTML formatting code |
|---|---|
| 1 | H1 |
| 2 | H2 |
| 3 | H3 |
| 4 | H4 |
| 5 | H5 |
| 6 | H6 |
There are two ways to specify the location of the results of a query in a template file:
| bold | lastupdated | table_urls |
| colheaders | reftext | URL |
| fixedfont | resultstitle | url_query |
| HTMLHeader | singlerow | webpagetitle |
| italic | tabborder |
The extended procedure that is called by sp_makewebtask can read both Unicode and non-Unicode template files. If a Unicode file contains a signature header, the header is removed when the HTML file is generated.
Important If table_urls is 1, url_query must be included to specify the query to be executed for retrieving hyperlink information, and URL and reftext cannot be specified.
| Value | Description |
|---|---|
| 1 (default) | Create page now. The Web job is created, executed immediately, and deleted immediately after execution. |
| 2 | Create page later. The stored procedure for creating the HTML document is created immediately, but execution of the Web job is deferred until the date and time specified by targetdate and targettime (optional). If targettime is not specified, the Web job is executed at 12:00 A.M. targetdate is required when whentype is 2. This Web job is deleted automatically after the targeted date and time have passed. |
| 3 | Create page every n day(s) of the week. The HTML document is created on day(s) specified in dayflags and at the time specified by targettime (optional), beginning with the date in targetdate. If targettime is omitted, the default is 12:00 A.M. targetdate is required when whentype is 3. The day(s) of the week are specified in dayflags, and more than one day of the week can be specified. Web jobs created with whentype is 3 are not deleted automatically and continue to run on the specified day(s) of the week until the user deletes them with sp_dropwebtask. |
| 4 | Create page every n minutes, hours, days, or weeks. The HTML document is created every n time period beginning with the date and time specified in targetdate and targettime. If targettime is not specified, the Web job is executed at 12:00 A.M. targetdate is required in this case. The job runs automatically every n minutes, hours, days, or weeks as specified by numunits and unittype, and continues to run until the user deletes them with sp_dropwebtask. |
| 5 | Create page upon request. The procedure is created without automatic scheduling. The user creates a HTML document by running sp_runwebtask and deletes it only with sp_dropwebtask. |
| 6 | Create page now and later. The HTML document is created immediately and re-created, as when whentype is 2. |
| 7 | Create page now and every n day(s) of the week. The HTML document is created immediately and re-created, as when whentype is 3, except targetdate is not required. |
| 8 | Create page now and periodically thereafter. The HTML document is created immediately and re-created, as when whentype is 4, except targetdate is not required. |
| 9 | Create page now and upon request. The HTML document is created immediately and re-created, as when whentype is 5. The task must be deleted manually. |
| 10 | Create page now and when data changes. Creates the page immediately and later whenever the data in the table changes. datachg is required with this value. |
Important SQL Server Agent must be running when a job is scheduled to run periodically; otherwise, the HTML page is not generated.
| Value | Day of the week |
|---|---|
| 1 (default) | Sunday |
| 2 | Monday |
| 4 | Tuesday |
| 8 | Wednesday |
| 16 | Thursday |
| 32 | Friday |
| 64 | Saturday |
To specify multiple days, add the values. For example, to specify Monday and Thursday, set dayflags to 18.
| Value | Description |
|---|---|
| 1 (default) | Hours |
| 2 | Days |
| 3 | Weeks |
| 4 | Minutes |
| Value | Description |
|---|---|
| 0 | Generates an unencrypted stored procedure but does not create the task. |
| 1 | Generates an encrypted stored procedure and generates the task. |
| 2 (default) | Generates an unencrypted stored procedure and generates the task. |
To place the ntext or image data in a separate HTML page, use this format to specify a value for blobfmt:
"%n% FILE=output_filename TPLT=template_filename URL=url_link_name..."
where
Note Do not add spaces before or after the equal sign (=) and do not put file names in quotation marks (‘).
Output file names end with a number that indicates successive rows, similar to singlerow. output_filename is required, but template_filename and url_link_name are optional. The FILE = output_filename is the full path to the output file location. If provided, url_link_name is the http:// link to the file that is accessible through the World Wide Web. If url_link_name is not provided, the full physical file name preceded by the file:/// tag is used as the url_link_name. The same syntax in blobfmt (%n% FILE=...) can be repeated for multiple text or image columns.
If template_filename is provided, use the <%insert_data_here%> method to indicate the data insertion point.
The URL text is part of the result set and is always the column after the original ntext or image column. This URL text column is not displayed as a separate column in the result set.
{TABLE=name[COLUMN=name]}[,...]
This parameter is required when whentype is 10. With this option, three triggers (UPDATE, INSERT, and DELETE) are created on the specified table (and columns) executing the Web task when these triggers are fired. If there are preexisting triggers on the table, sp_runwebtask is added to the end of the trigger, provided that the trigger is not created with WITH ENCRYPTION, and the COLUMN field specification in this parameter is ignored. If there is an existing trigger on the table created with the WITH ENCRYPTION option, sp_makewebtask fails.
0 (success) or nonzero (failure)
Important The return code values have changed from earlier versions of Microsoft SQL Server.
None
For scheduled tasks, all errors are reported in the Microsoft Windows NT® application log on the computer running SQL Server, and have a source of xpsqlweb.
Important The sp_dropwebtask, sp_makewebtask, and sp_runwebtask stored procedures can be run only on SQL Server versions 6.5 and later.
The SQL Server Web Assistant provides an interface for using the sp_makewebtask stored procedure. For more information about creating Web pages with the Web Assistant, see Using the Web Assistant Wizard.
Fonts available for HTML documents depend upon the capabilities of your Web browser software. Consult your browser software for information about font availability and HTML formatting.
Important All Microsoft Windows® 95/98 Web Assistant users must have user accounts in the database being used. Use sp_adduser to add accounts to each database a user may access. When running the Windows 95/98 operating system, an on-demand task can only be run by the task owner or the system administrator.
The user must have SELECT permissions to run the specified query and CREATE PROCEDURE permissions in the database in which the query will run. The SQL Server account must have permissions to write the generated HTML document to the specified location. Only the members of the sysadmin fixed server role can impersonate other users.
This example creates an HTML document and upon request retrieves five book titles and prices, five publisher names, and five author first and last names. In this document, placement of data is specified by the <%insert_data_here%> marker.
This section shows the template file named C:\Web\Multiple.tpl.
Note For this example to work properly, the template file code presented here must be saved in a file named C:\Web\Multiple.tpl. You must also create the C:\Web directory before saving the template in the C:\Web directory.
<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>Publiher'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%>
<P>
<A HREF = "http://www.microsoft.com">Microsoft</A><P>
<A HREF = "http://www.microsoft.com/msdn">MSDN</A><P>
</BODY>
</HTML>
This section of the example shows using sp_makewebtask to execute the query.
USE pubs
GO
EXECUTE sp_makewebtask @outputfile = 'C:\WEB\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:\WEB\MULTIPLE.TPL',
@dbname = 'pubs', @rowcnt = 5, @whentype = 9
GO
Here is the result set:
<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>
<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>
<HR>
<P>
<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>
<P>
<TABLE BORDER>
<TR> <TH ALIGN=CENTER>ID</TH> <TH ALIGN=LEFT><I>Publiher'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>
<P>
<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>
<P>
<A HREF = "http://www.microsoft.com">Microsoft</A><P>
<A HREF = "http://www.microsoft.com/msdn">MSDN</A><P>
</BODY>
</HTML>
This example creates a two-column table called my_favorite_sites. The first column url_def is the URL to a specific Web location, and the second column display_text is the hyperlink text for the corresponding URL. After creating the table and filling it with values, the HTML document is created.
USE pubs
GO
CREATE TABLE my_favorite_web_sites(url_def varchar(255), display_text varchar(255) NULL)
GO
INSERT my_favorite_web_sites(url_def, display_text)
VALUES ('http://www.micsosoft.com', 'Microsoft Home Page')
INSERT my_favorite_web_sites(url_def) VALUES ('http://www.yahoo.com')
GO
EXECUTE sp_makewebtask @outputfile = 'C:\WEB\URL.HTM',
@query='SELECT title, price FROM titles ORDER BY price desc',
@table_urls = 1, @tabborder = 0, @lastupdated=0, @colheaders = 0,
@url_query= 'SELECT url_def, display_text FROM
my_favorite_web_sites', @whentype = 9
GO
Here is the result set:
<HTML>
<HEAD>
<TITLE>Microsoft SQL Server Web Assistant</TITLE>
</HEAD>
<BODY>
<H1>Query Results</H1>
<HR>
<P>
<P><TABLE BORDER=0>
<TR><TD><TT>But Is It User Friendly?</TT></TD><TD><TT>22.9500</TT></TD></TR>
<TR><TD><TT>Computer Phobic AND Non-Phobic Individuals: Behavior Variations</TT></TD><TD><TT>21.5900</TT></TD></TR>
<TR><TD><TT>Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean</TT></TD><TD><TT>20.9500</TT></TD></TR>
<TR><TD><TT>Secrets of Silicon Valley</TT></TD><TD><TT>20.0000</TT></TD></TR>
<TR><TD><TT>The Busy Executive's Database Guide</TT></TD><TD><TT>19.9900</TT></TD></TR>
<TR><TD><TT>Straight Talk About Computers</TT></TD><TD><TT>19.9900</TT></TD></TR>
<TR><TD><TT>Silicon Valley Gastronomic Treats</TT></TD><TD><TT>19.9900</TT></TD></TR>
<TR><TD><TT>Prolonged Data Deprivation: Four Case Studies</TT></TD><TD><TT>19.9900</TT></TD></TR>
<TR><TD><TT>Sushi, Anyone?</TT></TD><TD><TT>14.9900</TT></TD></TR>
<TR><TD><TT>Cooking with Computers: Surreptitious Balance Sheets</TT></TD><TD><TT>11.9500</TT></TD></TR>
<TR><TD><TT>Fifty Years in Buckingham Palace Kitchens</TT></TD><TD><TT>11.9500</TT></TD></TR>
<TR><TD><TT>Is Anger the Enemy?</TT></TD><TD><TT>10.9500</TT></TD></TR>
<TR><TD><TT>Emotional Security: A New Algorithm</TT></TD><TD><TT>7.9900</TT></TD></TR>
<TR><TD><TT>Life Without Fear</TT></TD><TD><TT>7.0000</TT></TD></TR>
<TR><TD><TT>You Can Combat Computer Stress!</TT></TD><TD><TT>2.9900</TT></TD></TR>
<TR><TD><TT>The Gourmet Microwave</TT></TD><TD><TT>2.9900</TT></TD></TR>
<TR><TD><TT>The Psychology of Computer Cooking</TT></TD><TD>n/a</TD></TR>
<TR><TD><TT>Net Etiquette</TT></TD><TD>n/a</TD></TR>
</TABLE>
<HR>
<A HREF = "http://www.micsosoft.com">Microsoft Home Page</A><P>
<A HREF = "http://www.yahoo.com">http://www.yahoo.com</A><P>
</BODY>
</HTML>
This example creates eight HTML documents from multiple queries and uses the single-row mode.
This is the query:
USE pubs
GO
EXECUTE sp_makewebtask @outputfile = 'C:\WEB\SROW.HTM',
@query = 'SELECT title, price FROM titles ORDER BY price desc
SELECT au_lname, au_fname FROM authors WHERE state = ''CA'' ',
@fixedfont = 0, @webpagetitle = 'Single row SQL Web Assistant',
@resultstitle = 'One row per page results', @singlerow = 1,
@rowcnt = 4,@URL = "http://www.microsoft.com",
@reftext = 'Microsoft Home Page'
GO
This is the first file of the result set called C:\Web\Srow1.htm:
<HTML>
<HEAD>
<TITLE>Single row SQL Web Assistant</TITLE>
</HEAD>
<BODY>
<H1>One row per page results</H1>
<HR>
<PRE>Last updated: Jun 17 1997 9:14AM</PRE>
<P>
<P><TABLE BORDER=1>
<TR><TH ALIGN=LEFT>title</TH><TH ALIGN=LEFT>price</TH></TR>
<TR><TD>But Is It User Friendly?</TD><TD>22.9500</TD></TR>
</TABLE>
<HR>
<A HREF = "http://www.microsoft.com">Microsoft Home Page</A><P>
<TABLE BORDER=0 CELLPADDING=6>
<TR><TD>More results can be found in:</TD>
<TD><A HREF = "SROW2.HTM">Next</A></TD>
</TR></TABLE>
</BODY>
</HTML>
This is the second file of the result set called C:\Web\Srow2.htm:
<HTML>
<HEAD>
<TITLE>Single row SQL Web Assistant</TITLE>
</HEAD>
<BODY>
<H1>One row per page results</H1>
<HR>
<PRE>Last updated: Jun 17 1997 9:14AM</PRE>
<P>
<P><TABLE BORDER=1>
<TR><TH ALIGN=LEFT>title</TH><TH ALIGN=LEFT>price</TH></TR>
<TR><TD>Computer Phobic AND Non-Phobic Individuals: Behavior Variations</TD><TD>21.5900</TD></TR>
</TABLE>
<HR>
<A HREF = "http://www.microsoft.com">Microsoft Home Page</A><P>
<TABLE BORDER=0 CELLPADDING=6>
<TR><TD>More results can be found in:</TD>
<TD><A HREF = "SROW1.HTM">First</A></TD>
<TD><A HREF = "SROW1.HTM">Previous</A></TD>
<TD><A HREF = "SROW3.HTM">Next</A></TD>
</TR></TABLE>
</BODY>
</HTML>
This example creates two HTML documents from multiple queries by using a template that places each book title and price in separate HTML files.
This is the template file named C:\Web\Datains.tpl:
<HTML>
<HEAD>
<TITLE>SQL Server Multiple Queries, Data Insert Markers, & 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>
<A HREF = "http://www.microsoft.com">Microsoft</A><P>
<A HREF = "http://www.microsoft.com/msdn">MSDN</A><P>
</BODY>
</HTML>
This is the query:
USE pubs
GO
EXECUTE sp_makewebtask @outputfile = 'C:\WEB\DATAINS.HTM',
@query = 'SELECT title, price FROM titles',
@templatefile = 'C:\WEB\DATAINS.TPL', @dbname = 'pubs',
@rowcnt = 2, @whentype = 9, @singlerow = 1
GO
This is the first file of the result set called C:\Web\Datains1.htm:
<HTML>
<HEAD>
<TITLE>SQL Server Multiple Queries, Data Insert Markers, & 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>
<TR> <TD><I> The Busy Executive's Database Guide </I> </TD>
<TD ALIGN=RIGHT><B> $19.9900</B></TD> </TR>
</TABLE>
<P>
<HR>
<A HREF = "http://www.microsoft.com">Microsoft</A><P>
<A HREF = "http://www.microsoft.com/msdn">MSDN</A><P>
<TABLE BORDER=0 CELLPADDING=6>
<TR><TD>More results can be found in:</TD>
<TD><A HREF = "DATAINS2.HTM">Next</A></TD>
</TR></TABLE></BODY>
</HTML>
This is the second file of the result set called C:\Web\Datains2.htm:
<HTML>
<HEAD>
<TITLE>SQL Server Multiple Queries, Data Insert Markers, & 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>
<TR> <TD><I> Cooking with Computers: Surreptitious Balance Sheets </I> </TD>
<TD ALIGN=RIGHT><B> $11.9500</B></TD> </TR>
</TABLE>
<P>
<HR>
<A HREF = "http://www.microsoft.com">Microsoft</A><P>
<A HREF = "http://www.microsoft.com/msdn">MSDN</A><P>
<TABLE BORDER=0 CELLPADDING=6>
<TR><TD>More results can be found in:</TD>
<TD><A HREF = "DATAINS1.HTM">First</A></TD>
<TD><A HREF = "DATAINS1.HTM">Previous</A></TD>
</TR></TABLE></BODY>
</HTML>
This example executes a single query and places the information in HTML documents. The publishers table is linked with the pub_info table to provide company logos in the HTML documents.
This is the template file called C:\Web\Blobsmp.tpl:
<HTML>
<HEAD>
<TITLE>Publishers PR Info</TITLE>
</HEAD>
<BODY>
<HR>
<PRE>
<%insert_data_here%>
</PRE>
</BODY>
</HTML>
This is the query:
USE pubs
GO
EXECUTE sp_makewebtask @outputfile = 'C:\WEB\BLOBSMP.HTM',
@query = 'SELECT pr_info, pub_name, city, state, country, logo,
pub_info.pub_id FROM pub_info, publishers
WHERE pub_info.pub_id = publishers.pub_id',
@webpagetitle = 'Publishers Home Page',
@resultstitle = 'Premier Publishers and Their Home Page Links',
@whentype = 9, @blobfmt='%1% FILE=C:\WEB\BLOBSMP.HTM
TPLT=C:\WEB\BLOBSMP.TPL %6% FILE=C:\WEB\PUBLOGO.GIF', @rowcnt = 2
GO
This is the main HTML document Blobsmp.htm, which contains hyperlinks to the logo bitmaps and to the Publisher’s Home Web pages:
<HTML>
<HEAD>
<TITLE>Publishers Home Page</TITLE>
<BODY>
<H1>Premier Publishers and Their Home Page Links</H1>
<HR>
<PRE><TT>Last updated: Jun 28 1996 3:15PM</TT></PRE>
<P>
<P><TABLE BORDER=1>
<TR><TH ALIGN=LEFT>pr_info</TH><TH ALIGN=LEFT>city</TH><TH ALIGN=LEFT>state</TH><TH ALIGN=LEFT>country</TH><TH ALIGN=LEFT>logo</TH></TR>
<TR><TD NOWRAP><A HREF = "file:///c:\web\blobfmt1.htm">New Moon Books</A></TD><TD NOWRAP><TT>Boston</TT></TD><TD NOWRAP><TT>MA</TT></TD><TD NOWRAP><TT>USA</TT></TD><TD NOWRAP><A HREF = "file:///c:\web\publogo1.gif">0736</A></TD></TR>
<TR><TD NOWRAP><A HREF = "file:///c:\web\blobfmt2.htm">Binnet & Hardley</A></TD><TD NOWRAP><TT>Washington</TT></TD><TD NOWRAP><TT>DC</TT></TD><TD NOWRAP><TT>USA</TT></TD><TD NOWRAP><A HREF = "file:///c:\web\publogo2.gif">0877</A></TD></TR>
</TABLE>
<HR>
</BODY>
</HTML>
Here are the first few lines of the first file of the result set called C:\Web\Blobsmp1.htm:
Note Not all output lines are shown here. Complete output appears in C:\Web\Blobsmp1.htm.
<HTML>
<HEAD>
<TITLE>Publishers PR Info</TITLE>
</HEAD>
<BODY>
<HR>
<PRE>
This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Books is located in Boston, Massachusetts.
...
This is sample text data for New Moon Books, publisher 0736 in the pubs database. New Moon Boo
</PRE>
</BODY>
</HTML>
This is the second file of the result set called C:\Web\Blobsmp2.htm:
<HTML>
<HEAD>
<TITLE>Publishers PR Info</TITLE>
</HEAD>
<BODY>
<HR>
<PRE>
This is sample text data for Binnet & Hardley, publisher 0877 in the pubs database. Binnet & Hardley is located in Washington, D.C.
...
This is sample text data for Binnet & Hardley, publisher 0877 in the pubs database. Binnet & Hardley is located in Washington, D.C.
</PRE>
</BODY>
</HTML>
| sp_enumcodepages | System Stored Procedures |
| sp_runwebtask |