• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 23. SQL Server and the Internet > The Web Assistant Wizard

The Web Assistant Wizard

The Web Assistant Wizard is a tool that helps you to quickly and easily publish SQL Server data as HTML. Here's how it works:

1.
From within Enterprise Manager, select Tools, Wizards. The Select Wizard dialog box appears (see Figure 23.1).

Figure 23.1. The Select Wizard dialog box includes the Web Assistant Wizard.


2.
Select the Web Assistant Wizard and click OK. The Web Assistant Wizard appears (see Figure 23.2).

Figure 23.2. The Web Assistant Wizard helps you publish SQL Server data to a Web page.


3.
Click Next. The Select Database step of the wizard appears (see Figure 23.3).

Figure 23.3. The Select Database step of the wizard allows you to select the database whose data you want to publish.


4.
Select the database whose data you want to publish, and click Next. The Start a New Web Assistant Job step appears (see Figure 23.4).

Figure 23.4. The Start a New Web Assistant Job step allows you to name the job and designate the data that you want to publish.


5.
Name the Web Assistant job and designate whether you want to publish data from tables, the result set of a stored procedure, or the data returned from a Transact-SQL statement that you enter. Make your selection and click Next to continue. The next step varies depending on which option you select. Figure 23.5 shows the next step when you opt to publish data from tables and columns that you select.

Figure 23.5. If you opt to publish data from tables and columns that you select, the wizard prompts you to select the tables and columns.


6.
Select the tables and columns whose data you want to publish. In Figure 23.5, CustomerID, CompanyName, ContactName, ContactTitle, Phone, and Fax are selected from the Customers table. Make your selection and click Next. The Select Rows step of the wizard appears (see Figure 23.6).

Figure 23.6. The Select Rows step of the wizard allows you to designate the rows that you want to publish.


7.
In the Select Rows step of the wizard, you can opt to publish all rows from the specified table or to designate criteria for the rows that you want to publish. Make your selection and click Next. The Schedule the Web Assistant Job step of the wizard appears (see Figure 23.7).

Figure 23.7. The Schedule the Web Assistant Job step of the wizard allows you to create a job that publishes data at specified intervals.


8.
You can opt to publish data one time, on demand, whenever the data changes, or at regularly specified intervals. If you opt to publish at regularly specified intervals and click Next, the wizard appears as in Figure 23.8.

Figure 23.8. Schedule how often the HTML document is updated.


9.
Designate a schedule for the job and click Next. The Publish the Web Page step of the wizard appears (see Figure 23.9).

Figure 23.9. Provide a name and location for the HTML document.


10.
Designate the name and location for the Web page, and click Next. The Format the Web Page step of the wizard appears (see Figure 23.10).

Figure 23.10. Designate whether you want the wizard to help you to format the page.


11.
Select the desired option and click Next. If you opt to have the wizard help you format the page, the Specify Titles dialog box appears (see Figure 23.11).

Figure 23.11. Designate title text and size information.


12.
Enter titles for the Web page and the table containing the data. Designate the table title font and click Next. The Format a Table step of the wizard appears (see Figure 23.12).

Figure 23.12. Designate formatting information.


13.
Designate formatting information and click Next. The Add Hyperlinks to the Web Page step of the wizard appears (see Figure 23.13).

Figure 23.13. Designate hyperlinks that you want to add to the page.


14.
Designate what hyperlinks you want to add to the page, and click Next. The Limit Rows step of the wizard appears (see Figure 23.14).

Figure 23.14. Designate formatting information.


15.
Indicate whether you want to return all rows of data. Also specify whether you want all the returned data to appear on one scrolling page or multiple linked pages. In Figure 23.14, only 10 rows will appear on each page. Click Next to continue. The final step of the wizard appears (see Figure 23.15).

Figure 23.15. The final step of the wizard allows you to write the Transact-SQL to a file.


16.
Click Write Transact-SQL to File if you want to generate a file containing Transact-SQL that you can run at any time. Click Finish when done. SQL Server notifies you that the process completed successfully.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint