Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » XML   (RSS)
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 | 2 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 | 3 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 | 4 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 | 4 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 | 0 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 | 4 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
Thursday, March 09, 2006 9:30 PM

Database Programming: A Word About XQuery Performance Tuning In SQL Server 2005

The validation strategy for an earlier post is revisited in light of the newly-gained insight that Query Costing functionality in SQL Server 2005 Management Studio does not provide accurate results for XQuery statements against unindexed XML.
Posted by Ward Pond | 0 Comments
Tuesday, March 07, 2006 5:30 PM

Loading An XML Document Into SQL Server: Another OPENROWSET Trick

A quick-and-dirty solution for importing file-based XML documents into SQL Server tables is discussed.
Posted by Ward Pond | 1 Comments
Sunday, February 19, 2006 8:45 PM

Database Programming: Applying APPLY -- Solving Parent Axis Access Performance Issues In XML Access In SQL Server 2005

"Parent axis access", a long-standing performance bottleneck in accessing data stored within XML, is addressed via use of SQL Server 2005's new CROSS APPLY operator.
Posted by Ward Pond | 3 Comments
Saturday, October 29, 2005 10:19 PM

XML Programming in SQL Server 2005

With the RTM of SQL Server 2005, excitement is understandably running very high in the SQL Server developer community.
Posted by Ward Pond | 0 Comments
More Posts Next page »
 
Page view tracker