SQLDOM for parsing HTML

 

This is the coolest thing I’ve found in SQL Server in the past 10 years.

SQLDOM project

SQLDOM is an easy and robust way to parse HTML directly into SQL tables, manipulate DOM nodes in a JQuery-like manner, and to render HTML from the SQL-based DOM. SQLDOM is written entirely in native T-SQL, and uses only temporary database objects (tempdb). No changes to user databases are required.

http://sqldom.sourceforge.net/