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

Chapter 23. SQL Server and the Internet > Web-Related Stored Procedures

Web-Related Stored Procedures

A few stored procedures are involved in the process of generating and updating Web pages with SQL Server data. They are sp_makewebtask, sp_runwebtask, and sp_dropwebtask. The sections that follow cover the details of each of these very powerful stored procedures.

sp_makewebtask

sp_makewebtask is a system stored procedure that receives a multitude of input parameters. This stored procedure is responsible for generating a Web task that publishes XML data. If you review the Transact-SQL file created in the final step of the Web Assistant Wizard, you will see that it executes the sp_makewebtask stored procedure. All of the options that you selected in the wizard appear as parameters to the stored procedure (see Figure 23.25). Furthermore, if you opted to update the HTML file each time the user updates, deletes, or inserts data, SQL Server creates triggers as well (discussed in the previous section).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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