Mr. Bad Example

We're all examples: some good, some bad, some ugly.

Browse by Tags

All Tags » Examples » XML (RSS)
XML Addict? SQL Junkie? I've got required reading for you.
Michael Rys posts links to three key white papers on XML storage, XQuery and XML indexing internals. What are you waiting for...? :)
Jeff Nolan demonstrates why I love XQuery.
He gets it and he offers a demo . It's happening... unstructured text search. Been a long time in coming and when it gets into the hands of users look out, a whole new way to manage information.
Non-obvious but true: SQL's XML type instances are not DOM documents by default
Darshan Sighn, publisher of YukonXML posted an interested question on the SQL2005 XML newsgroup yesterday asking how to force an untyped XML instance to be like an normal XML document where there is a single root element. I'm not sure there's a way to...
Coolest InfoPath Post ever... at least so far.
So how do you use InfoPath and SQL Server 2005 Service Broker together? Rushi Desai to the rescue: Integerating InfoPath with SQL Server 2005 . Man this guy is cranking out the good stuff!
Example: Using .nodes() to shred XML
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...
Posted: Nov 15 2004, 09:19 AM by ktegels | with no comments
Filed under: , ,
Example: Loading RSS feeds into an SQL Server 2005 XML column Redux
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...
Example: Loading RSS feeds into an SQL Server 2005 XML column
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...
Example: Unioning XQueries results from Variable instances
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...
Just the basics of SQL Server 2005 XML Schema Management
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