sqlserver2005读取XML文件
<?xml version="1.0" encoding="gb2312" ?> 
- <BTSINFO>
  <VERSION READONLY="true">0820040500000000</VERSION> 
- <EDIT_AREA>
- <BTS SYSTEM="2" ALIAS="SY110三亚假日酒店">
- <CELL_1X>
  <CELL CELLID_READONLY="0" PHYCELLID_READONLY="0" CI="31101" PILOT_PN="45" REG_ZONE="3" LAC="3" MSCOFFICEID="255" /> 
  <CELL CELLID_READONLY="1" PHYCELLID_READONLY="1" CI="31102" PILOT_PN="213" REG_ZONE="3" LAC="3" MSCOFFICEID="255" /> 
  </CELL_1X>
- <CELL_DO>
  <CELL CELLID_READONLY="0" PHYCELLID_READONLY="0" PILOT_PN="45" SUBNETINDEXID="" SECTORID="00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00" /> 
  <CELL CELLID_READONLY="1" PHYCELLID_READONLY="1" PILOT_PN="213" SUBNETINDEXID="" SECTORID="00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00" /> 
  </CELL_DO>
  </BTS>
  </EDIT_AREA>
- <READONLY_AREA>
- <ASSISTANT_AREA>
  <COMMON BTSTYPE="0" BTSVERSION="20" ISINCLUDEDOCELL="true" CELLNUM_DO="2" ISINCLUDEDOCHM="true" CELLNUM_1X="2" FWDPOWER1X="true" BTSPARAMETER="true" CELLNUM="2" /> 
- <CARRIERLIST FREQNUMBER="3" CARRIERIDS="0,1,5" CARRIERNUM_1X="4" CARRIERNUM_DO="2">
  <CARRIER CARRIERID="0" CDMA_FREQ="283" BAND_CLASS="0" /> 
  <CARRIER CARRIERID="1" CDMA_FREQ="201" BAND_CLASS="0" /> 
  <CARRIER CARRIERID="5" CDMA_FREQ="37" BAND_CLASS="0" /> 
  </CARRIERLIST>
  </ASSISTANT_AREA>
- <SQLSCRIPT>
  <SQL>update b_sysfunction set flag = 0,starttime = getdate()</SQL> 
- <!-- B_SYSTEM
  --> 
- <!-- DEVID_B,SYSTEM,BTSTYPE,BTSVERSION,LOCATIONNAME,USERdEFINEDsTATE,SWVERSION,ALIAS_B,UCFSNCHECK,ABISMODE,SERIALNUMBER,RESERVED1,RESERVED2,RESERVED3,TESTE1WIDTH,POWERTYPE,ENABLECLOSEFWDRIM,CLOSEFWDRIM,OPENFWDRIM,CFRTIMER,BSMODE,ENABLEDISDELAY,UPSINFO,WORKTIME_START,WORKTIME_END,isAllowAllShutdown,SRACKMODE,crcmode,ABISALLOCRULE,MultiPlexing,province,CITY,county,address
  --> 
  <SQL>insert into B_SYSTEM (DEVID_B,SYSTEM,BTSTYPE,BTSVERSION,LOCATIONNAME,USERdEFINEDsTATE,SWVERSION,ALIAS_B,UCFSNCHECK,ABISMODE,SERIALNUMBER,RESERVED1,RESERVED2,RESERVED3,TESTE1WIDTH,POWERTYPE,ENABLECLOSEFWDRIM,CLOSEFWDRIM,OPENFWDRIM,CFRTIMER,BSMODE,ENABLEDISDELAY,UPSINFO,WORKTIME_START,WORKTIME_END,isAllowAllShutdown,SRACKMODE,crcmode,ABISALLOCRULE,MultiPlexing,province,CITY,county,address) values (#DEVID_B#,#SYSTEM#,0,20,NULL,NULL,NULL,'#BTS_ALIAS_B#',1,0x01,'',NULL,NULL,NULL,0,0,0,7,66,60,0,0,0,0,0,0,0,0,NULL,0,NULL,NULL,NULL,NULL)</SQL> 
- <!-- B_SENSORCFG
  --> 
- <!-- devid_b,system,sensorid,highlimit,lowlimit,isconfigure
  --> 
  <SQL>insert into B_SENSORCFG (devid_b,system,sensorid,highlimit,lowlimit,isconfigure) values (#DEVID_B#,#SYSTEM#,2,40,5,1)</SQL> 
  <SQL>insert into B_SENSORCFG (devid_b,system,sensorid,highlimit,lowlimit,isconfigure) values (#DEVID_B#,#SYSTEM#,3,85,2,0)</SQL> 
  <SQL>insert into B_SENSORCFG (devid_b,system,sensorid,highlimit,lowlimit,isconfigure) values (#DEVID_B#,#SYSTEM#,4,-500,-