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 ...
Get Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
