Design of Data Exchange Interface Between XML and SQL Server
Wei Xiuting
Abstract
Wei Xiuting
Abstract
SQL Server 2000 imports FOR XML and OPENXML to enhance its support for XML.Based on these kinds of support,this paper puts forward a design method for the data exchange interface between XML and SQL Server 2000.It constructs stored procedures in SQL Server database and calls them by ADO in order to achieve the data format exchange between them.
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.
SQL Server 2000 imports FOR XML and OPENXML to enhance its support for XML.Based on these kinds of support,this paper puts forward a design method for the data exchange interface between XML and SQL Server 2000.It constructs stored procedures in SQL Server database and calls them by ADO in order to achieve the data format exchange between them.
Key concepts: Computer science, Business Intelligence Markup Language, Database, Streaming XML, XML database, Data Transformation Services, SQL/PSM, SQL injection