Tips on parsing and sculpting XML from within a SQL 2005 stored procedure  Read more...

Not very often I run across something with zero matches in a search engine, but had it happen recently. I had set up a simple demo of a sparse column set and happened to look at the execution plan, was interested to see that the Compute Scalar was backed by ConvertSVtoXML. This was on a select from a table with one row, and then, being a little more curious, updated it with an xml fragment I saw a call to ConvertXMLtoResv. I’d venture that those serve to convert back/forth from XML storage.  Read more...

SQL Server 2005 and 2008 provide native XML data type and provides extensive support for XML data processing. The easy conversion from XML to a relational table provides a way for set-based updates based on user input.   Read more...

In part 2 of this series, Mohd Nizamuddin looks at sending multiple rows to the database from an application using XML.  Read more...

Now that hierarchical data structures are popular again because of XML, their full hierarchical processing is still being limited to flat two dimensional linear path processing by relational processing. This will change when database professionals realize that ANSI SQL relational processing can now support full multipath nonlinear hierarchical processing.  Read more...

New author Mohd Nizamuddin brings us the start of a series that talks abuot how you can send multiple rows to the database from an application.  Read more...

This article is an attempt to explain the application of new XML support in SQL Server 2005 for efficient data storage and performance.  Read more...

This next few installments of this series from MVP Jacob Sebastian will deal with how to modify XML documents. Part 1 looks at XQUERY.  Read more...

Continuing with his series on loading and transforming XML data, Leo Peysakhovich shows how to create the generic process to perform the convesions.  Read more...

With a continuation of his last article on auditing, Leo Peysakhovich enhances his solution to capture more details using XML.  Read more...

Longtime author Leo Peysakhovich brings us a new series on converting XML data into regular data. This article examines validating the XML data against a schema.  Read more...

Learn how you can split a delimited string in a single query using XML with Divya Agrawal.  Read more...

The FOR XML clause in SQL Server causes a lot of difficulty, mainly because it is rather poorly explained in Books-on-Line. We challenged Bob Sheldon to make it seem simple. Here is his sublime response.  Read more...

Sometimes there is a need to process files in a folder, but first you need to determine which files need to be processed compared to older files that have already been processed. There are several ways that this can be done, but in this tip I show you a way this can be done using SQL Server and XML.  Read more...

Continuing with his series on using auditing information to roll transactions forward or back, David McKinney shows us how to generate audit triggers using XML.  Read more...

Get an overview of how to set up and use XML Web Services using SOAP/HTTP inside SQL Server 2005 (formerly known as "Yukon"). Illustrative examples are included. To get the most from this paper, you should have a basic understanding of Web service technologies including HTTP, SOAP, and WSDL.  Read more...

XML Data Modification Language (XML DML) allows you to modify and update XML data. When working with SQL Server Databases, this is the most efficient way to modify elements in an XML column, yet the techniques of using XML-DML have not been well, or simply, described - up until now. Robert Sheldon presents a practical workbench to show the various modify methods  Read more...

Follow a detailed walkthrough of using the Web Service Task to connect to a web service and return an XML result.  Read more...

Creating KML files for many of the GIS applications such as Google Earth can be an easy and rich part of your business intelligence efforts  Read more...

Loading and processing XML files into SQL Server tables can be simple, thanks to a method that uses SQL Server functions and XPath expressions.  Read more...

Learn how you can split a delimited string in a single query using XML with Divya Agrawal.  Read more...

This next few installments of this series from MVP Jacob Sebastian will deal with how to modify XML documents. Part 1 looks at XQUERY.  Read more...

Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.  Read more...