基于存储过程的XML和SQL Server 2000数据交换的实现

Realization of XML and SQL Server 2000 Data Exchange Based on Stored Procedure

通过使用存储过程实现了数据在XML和SQL Server 2000之间的相互转换。使用C#程序先将嵌套的XML文件的数据插入数据库中,接着将数据库中的数据取出来保存在XML文件中。操作过程中不仅保持了数据的正确性,而且保持了XML文件的样式。使用存储过程可以大大简化程序的规模和对数据库的操作。

Data exchange between XML and SQL Server 2000 is realized using the stored procedure. The data in nested XML document is inserted into database, and then the data in database is selected and saved in XML document using C# program. The process not only keeps the correctness of data but keeps the pattern of XML document. Using stored procedure can reduce greatly the scale of the program and the operation on database.