Browse by Tags

XML Puzzle Contest Winners

In the last entry I promised to share the answer to the XML puzzle today. Here's a quick recap of the question - SQL 2005 BOL gives the following example of a full-text search XML thesaurus file: <XML ID="Microsoft Search Thesaurus"> <thesaurus xmlns="x-schema:tsSchema.xml">...

Posted to Pro SQL Server XML (Weblog) by Mike C on 06-20-2008
Unmatched Nodes in XQuery

In a previous post I talked about performing "inner joins" in XQuery. The basic idea is that the inner join is simply a special case of a Cartesian product, or "cross join". In this post I'm going to briefly look at another common SQL-style join condition that can be duplicated...

Posted to Pro SQL Server XML (Weblog) by Mike C on 02-24-2008
Retrieving Recursive Hierarchical Data

Part of the promise of XML is that it makes modeling hierarchical data relatively painless. The hierarchical structure of XML automatically provides context to your data. Consider the following simple example: < General name = " Grant " > < Colonel name = " Sanders " >...

Posted to Pro SQL Server XML (Weblog) by Mike C on 02-15-2008
Inner Joins in XQuery

One of the more interesting features of XQuery is FLWOR expressions (FLWOR stands for "for, let, where, order by, return", the keywords in the FLWOR expression vocabulary). FLWOR expressions have several capabilities, many of which are well-documented, but some of which get little attention...

Posted to Pro SQL Server XML (Weblog) by Mike C on 02-10-2008
Create a Dynamic Logging Trigger With XML

One of the more common uses of triggers is to create data manipulation language (DML) logging functionality. Essentially you can intercept and log inserts, updates, and deletes to tables. In the simplest case it's enough to know that one of these operations has occurred on a table, the date/time...

Posted to Pro SQL Server XML (Weblog) by Mike C on 01-26-2008
Xml Data Type: nodes() Method

I've decided to kick this blog off with a double-feature. In the last post I gave an example of shredding XML query plans with the nodes() method. In this one we'll discuss the nodes() method in a little more detail. In a previous post on the Pseudo-Random blog, I recommended that everyone who's...

Posted to Pro SQL Server XML (Weblog) by Mike C on 01-22-2008
"Exact Numerics" Re-visited

Wow, seems like I have a lot to write about today. I just noticed a blog by SQL Server guru Hugo Kornelis about the difference between "exact" and "approximate" numeric data types. (Hugo's blog entry is here: http://sqlblog.com/blogs/hugo_kornelis/archive/2007/10/17/so-called...

Posted to Pseudo-Random (Weblog) by Mike C on 10-20-2007
YASSAS ("Yet Another SQL Server Array Splitter")

There are billions of VARCHAR -array-splitting routines out there to compensate for the lack of true Arrays and Array Parameters in SQL Server. In yesterday's blog I talked about passing in and splitting an array with more than 8,000 characters [the VARCHAR max]. Other times you might know that your...

Posted to Pseudo-Random (Weblog) by Mike C on 03-10-2006
8,001 Bytes And Beyond (SQL Arrays)

I recently sat down to try to figure the best way to pass a comma-delimited array to a SQL Server 2000 stored procedure. The catch? It had to handle arrays larger than 8,000 bytes - the upper limit for VARCHAR data. SQL Guru and newsgroup regular Erland Sommarskog posted a great piece on parsing arrays...

Posted to Pseudo-Random (Weblog) by Mike C on 03-09-2006
Sorting Book Chapters

A while back a SQL newsgroup poster asked a question about sorting chapter numbers for a book in SQL. As anyone who's picked up a programming book or technical paper online knows, it's common practice to number chapters in the format '1.1', '2.1.3', '3.4.5.6', etc. The...

Posted to Pseudo-Random (Weblog) by Mike C on 07-24-2005

Page 1 of 2 (15 items) 1 2 Next >