Role of Web Assistant Wizard and Displaying Records from the XML_EX Database
Assistant Wizard in SQL 6.5 provides a wizard that steps the process of creating
a Web Task, hiding all the underlying functionality with the Graphical User Interface.
The SQL Server Web Assistant is a simple way to quickly generate Web Tasks.
Click on Enterprise manager by selecting Start, Programs, Microsoft QL Server
7.0. A small window will appear.
table Bookinfo is created. The datas should be entered in the table. Double click
on the Tables icon, a list of available tables (tables created by the system and
user) will appear. Right click on the table Bookinfo, selecting Open Table, returning
all rows. A window called Data in Table BookInfo The
values are entered in the window and closed.
The first step is to create a template file called Bookinfo.tpl. The procedure for creating the file is the same as an xml document.
From the programs menu the Microsoft SQL Server 7.0 and then the Enterprise manager is selected from the programs menu.
A server group is selected by clicking the icon.
The various components of the server group such as the databases contained Management tools, Data Transformation Services etc are displayed. The Database such as xml_ex is selected.
The various user defined and system tables available in the xml_ex database are displayed. Over the tool bar click on the icon tool tip displaying Run a Wizard .
The window that appears shows various wizards available. The Web Assistant Wizard is selected and the ok button is clicked.
A welcome screen that guides through the steps needed to complete the wizard appears. The Next button is then clicked.
The list of all the databases available in the server group are displayed. The desired database is selected. In the example, xml_ex (name of the database ) is selected and Next button is clicked.
A text field is provided for entering the name of the Web Assistant Wizard .The data can be retrieved from the database in three different ways. They are as follows:
Data from the tables and columns- This is a straight forward method of extracting
information. The columns that should be included in the output are selected after
selecting the table.
The list of tables available in the selected database is displayed. When a table is chosen, the fields available in the table are displayed. The required fields alone can be selected by selecting the field and the ADD button is being clicked. If all fields are required , then the AddAll button is clicked, followed by Next button.
screen that allows the user to filter the records based on the criteria appears.
The three different types of filters are:
various refresh options are:
Any one of the above options is selected and the Next button is being clicked.
The window that appears, requires the path where the xml file should be created and saved. The directory on the server should be specified. The Next button is clicked then.
screen that appears next displays various options regarding the retrieval of rows.
The final screen appears that requires the confirmation to complete the wizard. Finally click the finish button. If the wizard is successful, the following message Web Assistant Wizard screen appears, followed by the clicking of Ok button.
Copyright - © 2004 - 2017 - All Rights Reserved.