Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Do SQL Server and ADO Support XML?

April 26, 2017Ado SQL Server support XML

0

Posted

Do SQL Server and ADO Support XML?

1 Answer

0

Posted

Microsoft ActiveX Data Objects (ADO) technology provides a number of ways to convert database record sets (collections of data records) into an XML format, as well as tools to take XML in a given structure and revert it back into any database that ADO supports (including SQL Server and Oracle databases). In addition, through the XML Data Source Object in MSXML2 and MSXML3, you can load arbitrary XML directly into ADO to generate recordsets. SQL Server 2000 also lets you set and retrieve XML directly through a URL in much the same way that you would call up a Web page. This is a powerful mechanism for working with data, because it essentially means that you can integrate your SQL Server data into XSL filters, into Web pages, basically anywhere that an XML document can go. Furthermore, you can set up custom templates for controlling how the XML gets produced from the SQL Server data, making the database a powerful tool for generating XHTML pages. Finally, applications such as BizTalk Ser