Browse by Tags
All Tags »
Examples »
XML »
SQL Server (
RSS)
I like doing things the simple way I guess. Here's an example of using the .nodes() method of an XML-type instance to produce a tabular shred of its data. Not hard once you figure out that its giving a new current context for each row. Continues here...
Kirk and I are having a lot of fun with this RSS issue. Here's an updated version of my previous example that copes with Unicode BOMs and pre-validates the fetched RSS before it attempts to store it. It demonstrates that typed XML really does validate...
There's been a brief discussion on the SQL Server 2005 XML newsgroup regarding RSS and the XML type on SQL, encoding and schema. In keeping with my recent series of code-heavy examples, here's the guts of a primvative little VB.NET console app that sucks...
There was a post this morning the SQL Server 2005 XML newsgroup that caught my eye. I don't know that I answered the poster's question exactly, but it lead to what I thought was an interesting example. So, here's another code-heavy article on showing...
I've posted my most code-dense article in ages over on SQLJunkies. It's a lifecycle walk-through of managing XML schema collections in SQL Server 2005 . And Mom said I couldn't just shut up and code...
More Posts