Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » XML   (RSS)
Monday, August 24, 2009 9:30 AM

Database Programming: Why I Like MERGE

In the wake of last month’s post on my new development efforts in SQL Server 2008, several of you have asked me to go into further detail.  This post is my first effort to answer those questions; right now, we’ll focus on these two , which relate
Posted by Ward Pond | 2 Comments
Wednesday, June 17, 2009 11:45 PM

Database Programming: Using the .modify() Method Against an XML Variable in SQL Server 2008

Make a note..  here’s my first useful programming tip for SQL Server 2008 (and yes, there will be more to come; I’m about a week and a half into my first SQL Server 2008 development project).. Way back in February of aught-seven, I shared Jerry’s
Posted by Ward Pond | 0 Comments
Thursday, February 26, 2009 10:30 PM

Database Programming: The String Concatenation XML Trick, Revisited

UPDATED 27 February 2009 for spelling I’ve got to pay more punctual attention to my comment pool.. RBarryYoung’s movingsql.com will be on my blog roll shortly after I get this posted (second attempt; first thwarted by a laptop hang. I have suspended unit
Posted by Ward Pond | 6 Comments
Tuesday, January 27, 2009 10:00 PM

SINGLE_BLOB Size Limit: An Affirmation for Bert

Bert left a comment on this post pointing out a limitation of “the other OPENROWSET trick” (the one which loads an XML file into a single XML column): I tried this, but had an error because my XML file is 6gB. The SINGLE_BLOB seems to be limited to 2gB
Posted by Ward Pond | 1 Comments
Friday, March 21, 2008 7:15 AM

Database Programming: The String Concatenation XML Trick, Finalized

It's an especially Good Friday when we can close the loop on a technical conversation, and I believe that our modifications to The Technique That Lance Found , also discussed here and here , are complete.  Scott Whigham left a comment on the most
Posted by Ward Pond | 5 Comments
Tuesday, March 18, 2008 5:15 PM

Database Programming: The String Concatenation XML Trick, Sans Entitization

When last we checked in on The Technique That Lance Found , Adam had noted that the method entitizes XML special characters, a state of affairs which limits its utility somewhat.  I tried to leverage Tony Rogerson's technique , which Adam passed
Posted by Ward Pond | 6 Comments
Saturday, March 15, 2008 12:30 AM

Database Programming: The String Concatenation XML Trick Revisited (Or, Adam Is Right, But We Can Fix It)

A find shared by one friend leads to correspondence from another.. The redoubtable Adam Machanic left a comment on The Technique That Lance Found which points out that special XML characters in a string will get entitized. As usual, Adam is correct. If
Posted by Ward Pond | 8 Comments
Thursday, March 13, 2008 12:00 PM

Database Programming: The String Concatenation XML Trick

Courtesy of my good friend and once-and-always colleague, Lance Larsen, who writes: I recently ran into this little trick. Joining two tables having a one-to-many relationship and stuffing a set of column values from the many side into a single column
Posted by Ward Pond | 8 Comments
Wednesday, February 20, 2008 9:15 PM

An Answer For Spazecaze: A Reasonable Method To Implement User Defined Fields

Spazecaze discovered a February, 2006 discussion of order of operations and poses the following question in its comment area : So how would you go about designing a database that allows for end user defined fields? For instance, a system is built to allow
Posted by Ward Pond | 3 Comments
Friday, March 09, 2007 7:30 PM

New To SSIS? Come Take A Guided Tour..

One of the more interesting and perhaps challenging aspects of a SQL Server 2000 to SQL Server 2005 upgrade is the migration from DTS to SSIS for ETL (Extract-Transform-Load) activities. SSIS isn't an upgrade of DTS, but is in fact an entirely new, and
Posted by Ward Pond | 0 Comments
Friday, February 02, 2007 7:45 PM

Database Programming: Using The modify() Method Against An XML Variable

Here's the first technical tid-bit on this blog in awhile, courtesy of a long-concluded internal conversation that I rediscovered when I was cleaning out three months' worth of email from my inbox. Roger wrote: I'm trying to use the modify() method against
Posted by Ward Pond | 0 Comments
Monday, September 11, 2006 5:00 PM

Database Programming: Sergey Offers Another FOR XML EXPLICIT Syntax For Steve

If you've worked with databases long enough, you develop a set of truisms that you carry around in your head. One of mine, related to building T-SQL syntax, is, "there are at least 87 ways to skin any particular cat." While we're still 85 methods short
Posted by Ward Pond | 3 Comments
Monday, September 11, 2006 12:45 PM

Database Programming: Buliding a FOR XML PATH Statement Containing Both an Element Value and an Attribute Associated With The Element

On Friday afternoon, I shared an answer to Steve's question seeking a FOR XML EXPLICIT query to produce this XML: < Product > < Category rank = " 0 " > Category Name </ Category > </ Product > Well, over the weekend my "geek beanie"
Posted by Ward Pond | 0 Comments
Friday, September 08, 2006 8:00 PM

Database Programming: Buliding a FOR XML EXPLICIT Statement Containing Both an Element Value and an Attribute Associated With The Element

Well, the title of this post is so long, I almost don't need to reconstruct Steve's question, but here it is.. I need to construct a FOR XML EXPLICIT statement that essentially produces something like < Product > < Category rank = " 0 " >
Posted by Ward Pond | 5 Comments
Wednesday, May 03, 2006 9:00 PM

Database Programming: SET Options That Impact XML Access In SQL Server 2005

SET options impacting XML access are described.
Posted by Ward Pond | 3 Comments
More Posts Next page »
 
Page view tracker