复制declare @xdoc xml   set @xdoc = <conn> <mysqlservername="192.168.1.120,新性3306"> <username="root"password=""/> <username="dba"password=""/> <username="user"password=""/> </mysql> <mssqlservername="192.168.1.110,1433"> <username="sa"password=""/> <username="dba"password=""/> <username="user"password=""/> </mssql> <excelid="1"path="c:\database\"filename="source1.xls"/> <excelid="2"path="d:\database\"filename="source2.xls"/> <excelid="3"path="e:\database\"filename="source3.xls"/> </conn> 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.