Sqlxml - sqlxml.org
General Information:
Latest News:
HOW TO: Get the XML text of a FOR XML query within SQL. 12 Sep 2004 | 06:52 am
Is there a way to get the XML text of a FOR XML query? Answer provided by Erland Sommarskog. Check Erland's website for more great SQL Server information. In SQL2000 you can do this: MSDALOCAL is ...
Using Metaproperties in OpenXML 13 Nov 2003 | 06:35 am
Goal: Using the following XML, insert three node records in the node table and then three two subnode records into the subnode table with a reference to the correct parent node. The node table uses a ...
How To: Shape FOR XML AUTO results using SQL views 5 Nov 2003 | 07:32 am
Sometimes it is easier to use FOR XML AUTO to retrieve XML from SQL Server than it is to use FOR XML EXPLICIT. However, if you're combining data from multiple tables you may not get results you expect...
How To: Use OpenXML on an Xml document with a default namespace 1 Nov 2003 | 03:53 am
Answer provided by Brian. Hopefully this will prevent another developer from working until 12:30 AM to solve a mystery. I looked for the answer to this one for 4 hours. None of the documentation, new...
How To: Insert and Update with OpenXML 29 Oct 2003 | 11:02 am
I would like to update existing record if the ID exists in the table, otherwise insert the record(node) into the table.. This is pretty easy to do. Below is an example that uses a table named 'test' ...
How To: Combine FOR XML AUTO queries using XSL 23 Oct 2003 | 01:51 pm
When constructing complex XML documents, many times the best solution is not to use FOR XML EXPLICIT but rather use a bunch of FOR XML AUTO queries and combine them with XSL. Below are a few examples ...
How To: Using XML BulkLoading with .Net Streams 21 Oct 2003 | 11:59 am
Answer provided by Craig Pearson Here is an example of how to use XML BulkLoading with .Net Streams.
How do you setup SqlXml 3.0 on Windows Server 2003? 13 Jun 2003 | 07:26 pm
This question comes up quite often in the newsgroups. Here are the steps to getting this setup. Download SqlXml 3.0 (this test was done with Sp2 Beta 1). Run the installation program. You will need ...
Why do I get a compilation error when importing the Microsoft.Data.SqlXml namespace? 15 Mar 2003 | 08:21 am
This is a pretty common question that many ASP.Net developers run into. If you want to use the SqlXml managed classes in ASP.Net without using the code-behind feature, you will probably run into this ...
How can I use aggregates and the group by clause with FOR XML? 15 Mar 2003 | 05:57 am
Is there anyway I could return an XML with a SUM/GROUP BY clause in the select?!? This is actually fairly simple to implement. For this example I will use the pubs database. The first step is to cre...
