Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Knowledge Base > SQL Server > SQLXML


Search:
What's New - What's Hot
You may receive the error "This document already has a DocumentElement node." - Part II     
Total Hits: 247  |  Today: 0Author: Harish      Rating:  
Read Reviews | Write Review |  Your Rating: 

In continuation to Part I of this article, we will examine how we can load the XML Fragment returned by the SQL FOR XML query, into a DataSet, to form a Well Formed XML Document....

You may receive the error "This document already has a DocumentElement node." - Part III     
Total Hits: 240  |  Today: 0Author: Harish      Rating:  
Read Reviews | Write Review |  Your Rating: 

In Part II, we examined how we can utilize the DataSet's intelligence to handle XML Format to overcome the "Document Element" issue while reading XML Data from SQL Server using FOR XML queries. We will examine a much more efficient way of handling SQL XML using the SQL XML Managed classes provided with the Microsoft SQL XML Managed Provider (Available for free download from Microsoft). Microsoft SQL XML introduces powerful set of Properties/Methods to manipulate XML Data from SQL Server FOR XML ...

SAMPLE: How to Retrieve Data Using a Template File in ATL OLE DB     
Total Hits: 232  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

OLEDBTemplate.exe demonstrates how to extract an XML stream from a SQL Server 2000 database using an XML template file....

SAMPLE: How to Retrieve Data Using a SQL XML Query in ATL OLE DB     
Total Hits: 223  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

OLEDBSQLXML.exe demonstrates how to create an ATL OLE DB client that extracts an XML Stream from a SQL 2000 Server using a SQL XML Query....

You may receive the error "This document already has a DocumentElement node." while trying to read XML Data retrieved using the FOR XML clause     
Total Hits: 254  |  Today: 0Author: Harish Ranganathan      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server 2000's FOR XML Clause provides great support in querying SQL Server Data and retrieving it in the form of XML. In other words, you can get an XML representation of the Result Set using the FOR XML Clause. So, if a select statement of select * from customers retrieves results in a sequential way, select * from customers FOR XML AUTO will retrieve the same in a XML Format. There are different methods to retrieve XML representation of Data using SQL Server 2000's FOR XML clause which is ...



Disclaimer - Privacy
© 2002-2017 DevASP.net