Parsing HTML In SQL Server

preview_player
Показать описание
T-SQL is probably not the tool you want to use to parse HTML. But what if you have no other option and you HAVE to use it to extract data from some webpage source code? In today's video we look at how you can use SQL Server's XML datatype and methods to help parse some simple HTML data.

Related blog post with more examples:

Follow me on Twitter:
Рекомендации по теме
Комментарии
Автор

What do t and c represent in the code?

ericpaez
Автор

Good video! Question - Is your website always down? I can never seem to get there. :(

stpieraf
Автор

oh god, the 60fps had my head spinning :) thanks, I am trying to parse HTML using xquery and it is a pain in the ass to begin with.

damarh