Publish Dynamic Data with SQL Server's Web Assistant Wizard

Step 3: Choose the Data Source from which you want to Publish Online

For sake of this example, we’ll use the Northwind database, which is created by default when installing SQL Server. After choosing the database mentioned above, you will notice the Wizard has three different ways of selecting data:

• Data from tables
• Results of stored procedures
• Data from a T-SQL statement

If you know how to write your own stored procedures and T-SQL statements (SQL Server's own dialect of the ordinary Structured Query Language), these can offer you great powers. Here, however, we’ll continue with the much simpler first option.

Step 4: Choose the Data you want to Publish Online

After picking that first and most straightforward option, you will get the opportunity to choose the appropriate tables and columns. Choose Employees, add the columns with first and last name, and click Next twice.

Step 5: Schedule the Update

Usually, you’d like to update your pages when SQL Server data changes, so pick the fourth option for this example. As you can see, it's also possible to schedule updates at regular intervals. Make sure you leave the option "Generate a Web page when the wizard is completed" on, so you can watch the results once we've finished.

Step 6: Indicate which Changes to Monitor

Last but not least, SQL Server needs to know which changes the HTML page should implement. Data modifications to any column will lead to the generation of a new Web page. Add the first and last name columns of the table Employees again, and click Next.