O'Reilly logo

Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Producing HTML from sp_makewebtask

Up to this point we've been exploring emitting HTML the old-fashioned way—through Transact-SQL and OSQL. SQL Server includes a much better way of translating data from a database into HTML: sp_makewebtask. Sp_makewebtask exposes a full-blown HTML production engine that you can use to create tasks that produce Web pages from SQL Server data.

One of the challenges of writing a SQL Server book is in trying to avoid replicating what's already covered in the Books Online while remaining thorough enough to be comprehensive and to reassure those who've purchased the book that their money was well spent. SQL Server's online documentation has long been one of its strong points. It's far more extensive, cohesive, and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required