Shulou(Shulou.com)05/31 Report--

This article shows you how to generate XML in SQLServer. The content is concise and easy to understand. It will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

SQLServer2000 is a well-functional database, using forXML statements can easily convert the results of execution into a XML, which can greatly improve the system efficiency and development speed, so how to generate XML in SQLServer2000? The following editor to explain how to generate XML in SQLServer2000?

How to generate XML in SQLServer2000

However, the way you use ADO (RequiredADO2.6) to access the returned XML is different from the original Recordset. If you still use Recordset to access, you can only get a XMLSchema in Unicode format, but not the content of XML.

In fact, this problem can be easily solved, but I thought I was familiar with ADO and didn't look at Help carefully, so I didn't find that ADO uses Stream to get and return XML.

The Command object has two properties, called InputStream and OutputStream, whose value is an IUnknown interface. You can assign an XMLParser interface to it, or directly use Request, Response, and so on. The advantage is that there is no need to generate a Recordset, there is no need to save the data, thus saving system overhead.

The above is how to generate XML in SQLServer. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.