Producing HTML from Transact-SQL
Because of its basic simplicity, HTML isn't terribly hard to produce. That's why, to this day, many hard-core HTML coders prefer simple tools like Notepad to all-encompassing products like Frontpage. Compared with its forerunner SGML, HTML is very basic indeed. As such, it's easy to program and easy to produce. In fact, you can emit HTML from Transact-SQL with very little effort at all.
Tables
Tables represent a natural display format for relational data. Because HTML offers direct support for tabular data display, it only makes sense to explore producing HTML tables from SQL Server data. HTML tables are delimited by <TABLE> tags and each row is delimited with <TR> tags. Each piece of data within a table is delimited ...
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.
