Study and Application of XML and SQL Server 2000 Data Exchange Based on ADO.NET
Jia Zhuo
Abstract
Jia Zhuo
Abstract
This paper introduces the concept and some characters of XML.Several methods of the XML and SQL Server 2000 data exchange are analyzed. In the SQL Server 2000 ,the SELECT statement is used to save the store query result in XML documents and the OPENXML statement is used to provide function storing XML documents in relational database,and the data exchange between XML and SQL Server 2000 is realized.
A significance statement is not available in the OpenAlex record.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
This paper introduces the concept and some characters of XML.Several methods of the XML and SQL Server 2000 data exchange are analyzed. In the SQL Server 2000 ,the SELECT statement is used to save the store query result in XML documents and the OPENXML statement is used to provide function storing XML documents in relational database,and the data exchange between XML and SQL Server 2000 is realized.
Key concepts: Computer science, Streaming XML, Business Intelligence Markup Language, Database, XML validation, Efficient XML Interchange, XML database, XML Encryption