Please Can I know the difference between using XML DOM(in any application language) and using the XML services of SQL Server 2000 to create XML data from SQL Server 2000 database?
The DOM is a specific API to access data that is already XML or has an XML
representation. It is useful in close-coupled programming environments and
where navigational access is more important than data storage and data
access cost.
SQL Server 2000 generates the XML in a streaming way that then can be
processed in a streaming pipeline or can be loaded into a DOM. The streaming
generation provides a more memory-efficient, more performant and scalable
way to generate XML than buffering all the data in a DOM and then passing
the DOM.
Best regards
Michael
"Rani Ponmathi" <ranibackup@.yahoo.com> wrote in message
news:0DC00FE5-67FB-4B08-BD83-84DF0809EE0D@.microsoft.com...
> Please Can I know the difference between using XML DOM(in any application
> language) and using the XML services of SQL Server 2000 to create XML
> data from SQL Server 2000 database?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment