´æ´¢¹ý³Ìbulk xmlÎļþÎÊÌ⣬¸ßÊÖÀ´£¡
ÓÐÈçÏÂxmlÎļþ£º
<?xml version="1.0" encoding="GB2312" standalone="no"?>
<BANKDATASET>
<RECORD id="1">
<name>rjzjh</name>
<price>jjjjjj</price>
</RECORD>
<RECORD id="2">
<name>rjzjh1</name>
<price>jjjjjj1</price>
</RECORD>
</BANKDATASET>
ÐèÒªÓô洢¹ý³Ìµ¼ÈëÊý¾Ý¿âÖУ¬ÓÃSQLµÄbulkʵÏÖ£¬´úÂëÈçÏ£º
DECLARE @strXmlFileName char(40)
set @strXmlFileName=N'D:\HZFTP\hzpower\001025950'+convert(varchar(10),@XmlDate,112)+N'.xml'
SELECT @doc=bulkcolumn from OPENROWSET(BULK 'D:\HZFTP\hzpower\00102595020100402.xml',SINGLE_BLOB) AS x
EXEC sp_xml_preparedocument @Idoc OUTPUT, @doc
insert into tb_hzpower_FMIS SELECT @XMLDate,* from OPENXML (@idoc, '/BANKDATASET/RECORD',2) with
(name char(30),price char(20)£©
µ«Óöµ½ÒÔÏÂÎÊÌ⣬Çë¸ßÊÖ½â¾ö£º
1¡¢ÈçºÎÈ¡³örecord ÖеÄidµÄÖµµ¼ÈëÊý¾Ý¿â£¬¼°with£¨id£¬name£¬price£©£¿
2¡¢BULK 'D:\HZFTP\hzpower\00102595020100402.xml'ºóÃæµÄÎļþÊǸö¶¯Ì¬µÄ±äÁ¿£¬Ã¿ÈÕÎļþÃû²»Í¬£¬ÎÒÊÔ¹ýÓÃbluk @strXmlFileNameºÍbulk ¡®strXmlFileName¡¯ ¶¼²»ÐУ¬ÇëÎÊÒªÈçºÎʵÏÖbulk ¶¯Ì¬ÎļþÃû£¿
xml?²»»á,¸øÄã¸öÁ¬½Ó,¿´ÊÇ·ñÓÐÓÃ?
SQLServer200
Ïà¹ØÎÊ´ð£º
txt ºÍXML ¸ñʽÏàÓ¦
²»½èÖúDataSet
µ¼Èë¶ÁÈ¡TXTÎļþ
È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔÊý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.)
½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ
¹ý·ºÃºº °ï¸öæÈö^^
²»»á£¬°ïÂ¥Ö÷ ......
ΪʲôÎҵijÌÐòµ÷ÓÃXMLÅäÖÃÎļþÖеİ¢À²®ÎÄÏÔʾ²»³öÀ´£¿ÆäËûµÄÓïÖÖ¶¼¿ÉÒÔ£¬ÈçÖÐÎÄ£¬Ó¢ÎÄ£¬µÂÎĶ¼¿É¡£
ÎÒ½«XMLµÄ±àÂë¸ÄΪutf-8ºÍunicodeµÄµ½µÃ½á¹û¶¼Ò»Ñù.
°¢À²®ÎĵÄ×Ö¿âÄãÓÐô£¿
ÓÐ,ÎÒµÄEXEÊÇ·ÅÔÚpc»úÉÏÖ´Ðе ......
ÏÖÔÚÎÒдÁË´æ´¢¹ý³Ì£¬°Ñ±íÀïÃæµÄÊý¾Ýµ¼³öµ½xmlÖУ¬ÏÖÔڵĸñʽÊÇ£º
<?xml version="1.0" encoding="GBK" ?>
<PEOPLE>
<PERSON PERSONID="1">
&l ......
˼·£ºÒªÓÃc#Éú³ÉÒ»¸ö²¥·Å»úµÄ²¥·ÅÁбíµÄxml£¬ÀýÈ磺
<daty datys='2010-04-05' datye='2010-05-01' > //ÕâÊDz¥·ÅµÄÈÕÆÚ¶Î
<time times='01:12:00' timee='02:30:00'> ......
XMLÎļþÄÚÈÝ£º
- <ResList>
<page>0</page>
- <resItem>
<resName>WWW</resName>
</resItem>
- <resItem>
&nb ......