Using HTML Template Files

To receive query results, you can use your own HTML template file. A template file is any HTML file with the marker <%insert_data_here%> to indicate where the query results should be inserted.

    To use a template file with the SQL Server Web Assistant

1. Add an <%insert_data_here%> marker to your HTML template file and save the changes. HTML tables are supported.
2. Start the SQL Server Web Assistant.
3. In the File Options screen, type the full path and name of the HTML file to be generated.
4. Select the A Template File Called option.
5. Type the full path and name of your HTML template file.

   If a template file is used, the options listed in the next section titled "Using SQL Server Web Assistant Formatting Options" do not apply.

6. To continue, choose the Next button. To exit, choose the Cancel button.

For more information on template files, see the sp_makewebtask @templatefile parameter description, later in this document.