Sign in
|
Join
Home
Blogs
Forums
BI
XML
FILESTREAM
DOTNET
TC
SQL Tools
Got a SQL Server or .NET question? Discuss it in the
forums
. (
SQL Server Forums
|
Dot NET Forums
)
First Time? You can support us by signing up. It takes only 5 seconds. Click
here
to sign up. If you already have an account, click here to
login
.
Jacob's Blog
Home
Contact
RSS for Posts
Recent Blog Posts
How to generate CDATA and NAMESPACE Declarations using...
FOR XML EXPLICIT Tutorial – Part 4
Another XML Shaping Example - using FOR XML PATH and...
FOR XML EXPLICIT Tutorial – Part 3
FOR XML EXPLICIT Tutorial - Part 2
FOR XML EXPLICIT Tutorial- Part 1
Most Viewed
FOR XML EXPLICIT Tutorial – Part 4
(3,540)
FOR XML EXPLICIT Tutorial- Part 1
(3,253)
FOR XML EXPLICIT Tutorial - Part 2
(2,290)
FOR XML EXPLICIT Tutorial – Part 3
(1,796)
How to generate CDATA and NAMESPACE Declarations using...
(907)
Another XML Shaping Example - using FOR XML PATH and...
(812)
Archive
August 2010 (5)
July 2010 (3)
June 2010 (9)
May 2010 (3)
April 2010 (5)
March 2010 (5)
February 2010 (4)
January 2010 (4)
December 2009 (3)
November 2009 (1)
October 2009 (4)
September 2009 (4)
August 2009 (14)
July 2009 (2)
June 2009 (15)
May 2009 (7)
April 2009 (1)
March 2009 (10)
February 2009 (8)
January 2009 (15)
December 2008 (1)
November 2008 (3)
October 2008 (14)
September 2008 (32)
August 2008 (30)
July 2008 (15)
June 2008 (6)
January 2008 (4)
December 2007 (6)
November 2007 (2)
October 2007 (1)
June 2007 (1)
January 2007 (1)
October 2006 (1)
July 2006 (1)
How to generate CDATA and NAMESPACE Declarations using FOR XML EXPLICIT
I was asked this question in one of the SQL Server forums recently. The OP wanted to generate an XML document with CDATA sections and NAMESPACE declarations. SQL Server 2005 introduced WITH XMLNAMESPACES() which is very handy to generate namespace declarations...
Posted:
02-06-2010 7:08 PM
by
Jacob Sebastian
| with
no comments
Filed under:
XML
,
FOR-XML-EXPLICIT
,
FOR XML
,
XMLNAMESPACES
,
jacob
FOR XML EXPLICIT Tutorial – Part 4
Continued from FOR XML EXPLICIT Tutorial – Part 3 This is a late addition to the 3 part FOR XML TUTORIAL I wrote last year. You can find Part 1 here , Part 2 here and Part 3 here . When generating the XML document, FOR XML EXPLICIT processes rows in the...
Posted:
01-07-2009 8:53 AM
by
Jacob Sebastian
| with
no comments
Filed under:
XML
,
FOR_XML
,
FOR-XML-EXPLICIT
Another XML Shaping Example - using FOR XML PATH and EXPLICIT
In many of the previous posts, we discussed about controlling the structure of the XML being generated with FOR XML. SQL Server 2005 introduced the PATH operator which provides a great extend of control over the shaping of the XML being generated. With...
Posted:
12-14-2007 9:15 AM
by
Jacob Sebastian
| with
4 comment(s)
Filed under:
XML
,
FOR_XML
,
FOR-XML-EXPLICIT
,
FOR_XML_PATH
FOR XML EXPLICIT Tutorial – Part 3
Continued from FOR XML EXPLICIT Tutorial - Part 2 Having fixed the problem with the sort order, let us go ahead with the rest of the code. Let us add Addresses under the AddressCollection node and come up with the final version of the code. We need to...
Posted:
12-14-2007 8:47 AM
by
Jacob Sebastian
| with
no comments
Filed under:
XML
,
FOR_XML
,
FOR-XML-EXPLICIT
FOR XML EXPLICIT Tutorial - Part 2
Continued from FOR XML EXPLICIT Tutorial- Part 1 Let us move ahead. Under each agent, we need a node named AddressCollection . Let us add the code for that. SELECT 1 AS Tag, NULL AS Parent, NULL AS 'Agents!1!' , NULL AS 'Agent!2!AgentID'...
Posted:
12-14-2007 8:27 AM
by
Jacob Sebastian
| with
no comments
Filed under:
XML
,
FOR_XML
,
FOR-XML-EXPLICIT
FOR XML EXPLICIT Tutorial- Part 1
With SQL Server 2005 we can generate XML output using different methods. Using TSQL keyword FOR XML along with AUTO, RAW, PATH and EXPLICIT we could generate almost any XML structure that we might need. PATH is a very powerful keyword which allows a great...
Posted:
10-14-2007 8:17 AM
by
Jacob Sebastian
| with
no comments
Filed under:
XML
,
FOR_XML
,
FOR-XML-EXPLICIT
Copyright © Beyondrelational.com