| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> mssql >> jiao ni zai SQL Server shu ju ku zhong dao ru dao chu shu ju
 

jiao ni zai SQL Server shu ju ku zhong dao ru dao chu shu ju

2008-07-19 08:21:44 编辑來源:互联网 评论
 
本文为【教你在SQL Server数据库中导入导出数据】的拼音翻译版
  zai wo men jian li yi ge shu ju ku shi , bing qie xiang jiang fen san zai ge chu de bu tong lei xing de shu ju ku fen lei hui zong zai zhe ge xin jian de shu ju ku zhong shi , you qi shi zai jin xing shu ju jian yan 、 jing hua he zhuan huan shi , jiang hui mian lin hen da de tiao zhan 。 xing hao SQL Server wei wo men ti gong le qiang da 、 feng fu de shu ju dao ru dao chu gong neng , bing qie zai dao ru dao chu de tong shi ke yi dui shu ju jin xing ling huo de chu li 。
  zai SQL Server zhong zhu yao you san zhong fang shi dao ru dao chu shu ju : shi yong Transact-SQL dui shu ju jin xing chu li ; tiao yong ming ling xing gong ju BCP chu li shu ju ; shi yong shu ju zhuan huan fu wu (DTS) dui shu ju jin xing chu li 。 zhe san zhong fang fa ge you qi te dian , xia mian jiu ta men de zhu yao te dian jin xing bi jiao 。
  yi 、 shi yong fang shi de bi jiao
  1. shi yong Transact-SQL jin xing shu ju dao ru dao chu
  wo men hen rong yi kan chu ,Transact-SQL fang fa jiu shi tong guo SQL yu ju fang shi jiang xiang tong huo bu tong lei xing de shu ju ku zhong de shu ju hu xiang dao ru dao chu huo zhe hui ji zai yi chu de fang fa 。 ru guo shi zai bu tong de SQL Server shu ju ku zhi jian jin xing shu ju dao ru dao chu , na jiang shi fei chang rong yi zuo dao de 。 yi ban ke shi yong SELECT INTO FROM he INSERT INTO。 shi yong SELECT INTO FROM shi INTO hou gen de biao bi xu cun zai , ye jiu shi shuo ta de gong neng shi zai dao shu ju zhi qian xian jian li yi ge kong biao , ran hou zai jiang yuan biao zhong de shu ju dao ru dao xin jian de kong biao zhong , zhe jiu xiang dang yu biao de fu zhi ( bing bu hui fu zhi biao de suo yin deng xin xi )。 er INSERT INTO de gong neng shi jiang yuan shu ju cha ru dao yi jing cun zai de biao zhong , ke yi shi yong ta jin xing shu ju he bing , ru guo yao geng xin yi jing cun zai de ji lu , ke yi shi yong UPDATE。
  SELECT * INTO table2 FROM table1
  --table1 he table2 de biao jie gou xiang tong
  INSERT INTO table2 SELECT * FROM table3
  --table2 he table3 de biao jie gou xiang tong
  
  dang zai yi gou shu ju ku zhi jian de jin xing shu ju dao ru dao chu shi , qing kuang hui bian de fu duo de duo 。 shou xian yao jie jue de shi ru he da kai fei SQL Server shu ju ku de wen ti 。
  zai SQL Server zhong ti gong le liang ge han shu ke yi gen ju ge zhong lei xing shu ju ku de OLE DB Provider da kai bing cao zuo zhe xie shu ju ku , zhe liang ge han shu shi OPENDATASOURCE he OPENROWSET。 ta men de gong neng ji ben shang xiang tong , bu tong zhi chu zhu yao you liang dian 。
  (1) tiao yong fang shi bu tong 。
  OPENDATASOURCE de shen shu you liang ge , fen bie shi OLE DB Provider he lian jie zi fu chuan 。 shi yong OPENDATASOURCE zhi xiang dang yu yin yong shu ju ku huo zhe shi fu wu ( dui yu SQL Server、Oracle deng shu ju ku lai shuo )。 yao xiang yin yong qi zhong de shu ju biao huo shi tu , bi xu zai OPENDATASOURCE(...) hou jin xing yin yong 。
  zai SQL Server zhong tong guo OPENDATASOURCE cha xun Access shu ju ku abc.mdb zhong de table1 biao
  SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
  'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=abc.mdb;Persist Security
  Info=False')...
  table1
  
  OPENROWSET xiang dang yu yi ge ji lu ji , ke yi jiang zhi jie dang cheng yi ge biao huo shi tu shi yong 。
  zai SQL Server zhong tong guo OPENROWSETE cha xun Access shu ju ku abc.mdb zhong de table1 biao
  SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'abc.mdb';
  'admin';'','SELECT * FROM table1')
  
  (2) ling huo du bu tong 。
  OPENDATASOURCE zhi neng da kai xiang ying shu ju ku zhong de biao huo shi tu , ru guo xu yao guo lv de hua , zhi neng zai SQL Server zhong jin xing chu li 。 er OPENROWSET ke yi zai da kai shu ju ku de tong shi dui qi jin xing guo lv , ru shang mian de li zi , zai OPENROWSET zhong ke yi shi yong SELECT * FROM table1 dui abc.mdb zhong de shu ju biao jin xing cha xun , er OPENDATASOURCE zhi neng yin yong table1, er wu fa cha xun table1。 yin ci ,OPENROWSET bi jiao OPENDATASOURCE geng jia ling huo 。
  2. shi yong ming ling xing BCP dao ru dao chu shu ju
  hen duo da xing de xi tong bu jin jin ti gong le you hao de tu xing yong hu jie kou , tong shi ye ti gong le ming ling xing fang shi dui xi tong jin xing kong zhi 。 zai SQL Server zhong chu le ke yi shi yong SQL yu ju dui shu ju jin xing cao zuo wai , huan ke yi shi yong yi ge ming ling xing gong ju BCP dui shu ju jin xing tong yang de cao zuo 。BCP shi ji yu DB-Library ke hu duan ku de gong ju 。 ta de gong neng shi fen qiang da ,BCP neng gou yi bing xing fang shi jiang shu ju cong duo ge ke hu duan da rong liang fu zhi dao dan ge biao zhong , cong er da da ti gao le zhuang zai xiao lv 。 dan zai zhi xing bing xing cao zuo shi yao zhu yi de shi zhi you shi yong ji yu ODBC huo SQL OLE DB de API de ying yong cheng xu cai ke yi zhi xing jiang shu ju bing xing zhuang zai dao dan ge biao zhong de cao zuo 。
  BCP ke yi jiang SQL Server zhong de shu ju dao chu dao ren he OLE DB suo zhi chi de shu ju ku de , ru xia mian de yu ju shi jiang authors biao dao chu dao excel wen jian zhong 。
  bcp pubs.dbo.authors out c:\temp1.xls
  -c -q -S"GNETDATA/GNETDATA" -U"sa" -P"password"
  
  BCP bu jin neng gou tong guo ming ling xing zhi xing , tong shi ye ke yi tong guo SQL zhi xing , zhe xu yao yi ge xi tong cun chu guo cheng xp_cmdshell lai shi xian , ru shang mian de ming ling ke gai xie wei ru xia xing shi 。
  EXEC master..xp_cmdshell 'bcp pubs.dbo.authors out
  c:\temp1.xls -c -q -S"GNETDATA/GNETDATA" -U"sa" -P"password"'
  3. shi yong shu ju zhuan huan fu wu (DTS) dao ru dao chu shu ju
  DTS shi SQL Server zhong dao ru dao chu shu ju de gai xin , ta chu you ju you SQL he ming ling xing gong ju BCP xiang ying de gong neng wai , huan ke yi ling huo di tong guo VBScript、JScript deng jiao ben yu yan dui shu ju jin xing jian yan 、 jing hua he zhuan huan 。
  SQL Server wei DTS ti gong le tu xing yong hu jie kou , yong hu ke yi shi yong tu xing jie mian dao ru dao chu shu ju , bing dui shu ju jin xing xiang ying de chu li 。 tong shi ,DTS huan yi com zu jian de xing shi ti gong bian cheng jie kou , ye jiu shi shuo ren he zhi chi com zu jian de kai fa gong ju dou ke yi li yong com zu jian shi yong DTS suo ti gong de gong neng 。DTS zai SQL Server zhong ke yi bao cun wei bu tong de xing shi , ke yi shi bao de xing shi , ye ke yi bao cun cheng Visual Basic yuan cheng xu wen jian , zhe yang zhi yao zai VB zhong bian yi bian ke yi shi yong DTS com zu jian le 。
  DTS he qi ta shu ju dao ru dao chu fang shi zui da de bu tong jiu shi ta ke yi zai chu li shu ju de guo cheng zhong dui mei yi xing shu ju jin xing shen du chu li 。 yi xia shi yi duan VBScript dai ma , zhe duan dai ma zai chu DTS li mei yi tiao ji lu shi zhi xing ,DTSDestination biao shi mu biao ji lu ,DTSSource biao shi yuan ji lu , zai chu li “ hun yin zhuang kuang ” shi , jiang yuan ji lu zhong de “ hun yin zhuang kuang ” zhong de 0 huo 1 zhuan huan cheng mu biao ji lu zhong “ yi hun ” huo “ wei hun ”。
  Function Main()
  DTSDestination(" xing ming ") = DTSSource(" xing ming ")
  DTSDestination(" nian ling ") = DTSSource(" nian ling ")
  If DTSDestination(" hun yin zhuang kuang ") = 1 Then
  DTSDestination(" hun yin zhuang kuang ") = " yi hun "
  Else
  DTSDestination(" hun yin zhuang kuang ") = " wei hun "
  End If
  Main = DTSTransformStat_OK
  End Function
  
  shang shu de san zhong shu ju dao ru dao chu fang fa ge you qi li bi , ta men zhi jian de xiang hu bi jiao ru tu 1 ru shi 。
  <>B er 、 xing neng de bi jiao
  shi yong Transact-SQL fang shi 。 ru guo shi SQL Server shu ju ku zhi jian de dao ru dao chu , su du jiang fei chang kuai , dan shi shi yong OPENDATASOURCE he OPENROWSET fang fa li yong OLE DB Provider da kai bing cao zuo shu ju ku shi su du hui man yi xie 。
  shi yong BCP ming ling fang shi 。 ru guo bu xu yao dui shu ju jin xing yan zheng deng cao zuo de hua , shi yong ta huan shi fei chang kuai de , zhe shi yin wei ta de nei bu shi yong c jie kou de DB-library, suo yi zai cao zuo shu ju ku shi su du you hen da de ti sheng 。
  shi yong DTS fang shi dao shu ju ying gai shi zui hao de fang shi le 。 you yu ta zheng he le Microsoft Universal Data Access ji shu yu Microsoft ActiveX ji shu , yin ci bu jin ke yi ling huo di chu li shu ju , er qie zai shu ju dao ru dao chu de xiao lv shi fei chang gao de 。
  zong jie
  SQL Server ti gong le feng fu de shu ju dao ru dao chu fang fa , zhe gei wo men ti gong le geng duo de xuan ze , dan shi zhe you hui gei wo men dai lai yi ge xin wen ti : ru he gen ju ju ti qing kuang xuan ze he shi de shu ju dao ru dao chu fang fa ne ? wo zai zhe li ti gong yi xie ge ren de jian yi , xi wang neng dui du zhe qi dao yi ding de zhi dao zuo yong 。
  ru guo shi zai SQL Server shu ju ku zhi jian jin xing shu ju dao ru dao chu shi , bing qie bu xu yao dui shu ju jin xing fu duo de jian yan , zui hao shi yong Transact-SQL fang fa jin xing chu li , yin wei zai SQL Server shu ju ku zhi jian jin xing shu ju cao zuo shi ,SQL shi fei chang kuai de 。 dang ran , ru guo yao jin xing fu duo de cao zuo , ru shu ju jian yan 、 zhuan huan deng cao zuo shi , zui hao huan shi shi yong DTS jin xing chu li , yin wei DTS bu guang dao shu ju xiao lv gao , er qie neng gou dui shu ju jin xing shen du kong zhi 。 dan shi DTS de bian cheng jie kou shi ji yu com de , bing qie zhe ge jie kou shi fen fu duo , yin ci , shi yong cheng xu tiao yong DTS jiang bian ye hui bian de hen fu duo , yin ci , dang shu ju liang bu shi hen da , bing qie xiang jiang shu ju dao ru dao chu gong neng jia ru dao cheng xu zhong , er qie mei you fu duo de shu ju chu li gong neng shi , ke yi shi yong OPENDATASOURCE huo OPENROWSET jin xing chu li 。
  BCP ming ling bing bu tai shi he tong guo cheng xu lai tiao yong , ru guo xu yao shi yong pi liang de fang shi dao shu ju , ke yi tong guo pi chu li wen jian tiao yong BCP ming ling , zhe yang zuo ji bu xu yao bian xie da liang de cheng xu , ye wu xu zai qi ye guan li qi zhong tong guo ge zhong cao zuo jie mian de qie huan lai jin xing shu ju dao ru dao chu 。 yin ci , ta bi jiao shi he zai ke hu duan wei an qi ye guan li qi huo shi yong SQL Server Express shi dui shu ju jin xing kuai su dao ru dao chu de chang he 。【原文】【汉音对照
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
zai wo men jian li yi ge shu ju ku shi , bing qie xiang jiang fen san zai ge chu de bu tong lei xing de shu ju ku fen lei hui zong zai zhe ge xin jian de shu ju ku zhong shi , you qi shi zai jin xing shu ju jian yan 、 jing hua he zhuan huan shi , jiang hui mian lin hen da de tiao zhan 。 xing hao SQL Server wei wo men ti gong le qiang da 、 feng fu de shu ju dao ru dao chu gong neng , bing qie zai dao ru dao chu de tong shi ke yi dui shu ju jin xing ling huo de chu li 。 zai SQL Server zhong zhu yao you san zhong fang shi dao ru dao chu shu ju : shi yong Transact-SQL dui shu ju jin xing chu li ; tiao yong ming ling xing gong ju BCP chu li shu ju ; shi yong shu ju zhuan huan fu wu (DTS) dui shu ju jin xing chu li 。 zhe san zhong fang fa ge you qi te dian , xia mian jiu ta men de zhu yao te dian jin xing bi jiao 。 yi 、 shi yong fang shi de bi jiao 1. shi yong Transact-SQL jin xing shu ju dao ru dao chu wo men hen rong yi kan chu ,Transact-SQL fang fa jiu shi tong guo SQL yu ju fang shi jiang xiang tong huo bu tong lei xing de shu ju ku zhong de shu ju hu xiang dao ru dao chu huo zhe hui ji zai yi chu de fang fa 。 ru guo shi zai bu tong de SQL Server shu ju ku zhi jian jin xing shu ju dao ru dao chu , na jiang shi fei chang rong yi zuo dao de 。 yi ban ke shi yong SELECT INTO FROM he INSERT INTO。 shi yong SELECT INTO FROM shi INTO hou gen de biao bi xu cun zai , ye jiu shi shuo ta de gong neng shi zai dao shu ju zhi qian xian jian li yi ge kong biao , ran hou zai jiang yuan biao zhong de shu ju dao ru dao xin jian de kong biao zhong , zhe jiu xiang dang yu biao de fu zhi ( bing bu hui fu zhi biao de suo yin deng xin xi )。 er INSERT INTO de gong neng shi jiang yuan shu ju cha ru dao yi jing cun zai de biao zhong , ke yi shi yong ta jin xing shu ju he bing , ru guo yao geng xin yi jing cun zai de ji lu , ke yi shi yong UPDATE。 SELECT * INTO table2 FROM table1 --table1 he table2 de biao jie gou xiang tong INSERT INTO table2 SELECT * FROM table3 --table2 he table3 de biao jie gou xiang tong dang zai yi gou shu ju ku zhi jian de jin xing shu ju dao ru dao chu shi , qing kuang hui bian de fu duo de duo 。 shou xian yao jie jue de shi ru he da kai fei SQL Server shu ju ku de wen ti 。 zai SQL Server zhong ti gong le liang ge han shu ke yi gen ju ge zhong lei xing shu ju ku de OLE DB Provider da kai bing cao zuo zhe xie shu ju ku , zhe liang ge han shu shi OPENDATASOURCE he OPENROWSET。 ta men de gong neng ji ben shang xiang tong , bu tong zhi chu zhu yao you liang dian 。 (1) tiao yong fang shi bu tong 。 OPENDATASOURCE de shen shu you liang ge , fen bie shi OLE DB Provider he lian jie zi fu chuan 。 shi yong OPENDATASOURCE zhi xiang dang yu yin yong shu ju ku huo zhe shi fu wu ( dui yu SQL Server、Oracle deng shu ju ku lai shuo )。 yao xiang yin yong qi zhong de shu ju biao huo shi tu , bi xu zai OPENDATASOURCE(...) hou jin xing yin yong 。 zai SQL Server zhong tong guo OPENDATASOURCE cha xun Access shu ju ku abc.mdb zhong de table1 biao SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=abc.mdb;Persist Security Info=False')... table1 OPENROWSET xiang dang yu yi ge ji lu ji , ke yi jiang zhi jie dang cheng yi ge biao huo shi tu shi yong 。 zai SQL Server zhong tong guo OPENROWSETE cha xun Access shu ju ku abc.mdb zhong de table1 biao SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'abc.mdb'; 'admin';'','SELECT * FROM table1') (2) ling huo du bu tong 。 OPENDATASOURCE zhi neng da kai xiang ying shu ju ku zhong de biao huo shi tu , ru guo xu yao guo lv de hua , zhi neng zai SQL Server zhong jin xing chu li 。 er OPENROWSET ke yi zai da kai shu ju ku de tong shi dui qi jin xing guo lv , ru shang mian de li zi , zai OPENROWSET zhong ke yi shi yong SELECT * FROM table1 dui abc.mdb zhong de shu ju biao jin xing cha xun , er OPENDATASOURCE zhi neng yin yong table1, er wu fa cha xun table1。 yin ci ,OPENROWSET bi jiao OPENDATASOURCE geng jia ling huo 。 2. shi yong ming ling xing BCP dao ru dao chu shu ju hen duo da xing de xi tong bu jin jin ti gong le you hao de tu xing yong hu jie kou , tong shi ye ti gong le ming ling xing fang shi dui xi tong jin xing kong zhi 。 zai SQL Server zhong chu le ke yi shi yong SQL yu ju dui shu ju jin xing cao zuo wai , huan ke yi shi yong yi ge ming ling xing gong ju BCP dui shu ju jin xing tong yang de cao zuo 。BCP shi ji yu DB-Library ke hu duan ku de gong ju 。 ta de gong neng shi fen qiang da ,BCP neng gou yi bing xing fang shi jiang shu ju cong duo ge ke hu duan da rong liang fu zhi dao dan ge biao zhong , cong er da da ti gao le zhuang zai xiao lv 。 dan zai zhi xing bing xing cao zuo shi yao zhu yi de shi zhi you shi yong ji yu ODBC huo SQL OLE DB de API de ying yong cheng xu cai ke yi zhi xing jiang shu ju bing xing zhuang zai dao dan ge biao zhong de cao zuo 。 BCP ke yi jiang SQL Server zhong de shu ju dao chu dao ren he OLE DB suo zhi chi de shu ju ku de , ru xia mian de yu ju shi jiang authors biao dao chu dao excel wen jian zhong 。 bcp pubs.dbo.authors out c:\temp1.xls -c -q -S"GNETDATA/GNETDATA" -U"sa" -P"password" BCP bu jin neng gou tong guo ming ling xing zhi xing , tong shi ye ke yi tong guo SQL zhi xing , zhe xu yao yi ge xi tong cun chu guo cheng xp_cmdshell lai shi xian , ru shang mian de ming ling ke gai xie wei ru xia xing shi 。 EXEC master..xp_cmdshell 'bcp pubs.dbo.authors out c:\temp1.xls -c -q -S"GNETDATA/GNETDATA" -U"sa" -P"password"' 3. shi yong shu ju zhuan huan fu wu (DTS) dao ru dao chu shu ju DTS shi SQL Server zhong dao ru dao chu shu ju de gai xin , ta chu you ju you SQL he ming ling xing gong ju BCP xiang ying de gong neng wai , huan ke yi ling huo di tong guo VBScript、JScript deng jiao ben yu yan dui shu ju jin xing jian yan 、 jing hua he zhuan huan 。 SQL Server wei DTS ti gong le tu xing yong hu jie kou , yong hu ke yi shi yong tu xing jie mian dao ru dao chu shu ju , bing dui shu ju jin xing xiang ying de chu li 。 tong shi ,DTS huan yi com zu jian de xing shi ti gong bian cheng jie kou , ye jiu shi shuo ren he zhi chi com zu jian de kai fa gong ju dou ke yi li yong com zu jian shi yong DTS suo ti gong de gong neng 。DTS zai SQL Server zhong ke yi bao cun wei bu tong de xing shi , ke yi shi bao de xing shi , ye ke yi bao cun cheng Visual Basic yuan cheng xu wen jian , zhe yang zhi yao zai VB zhong bian yi bian ke yi shi yong DTS com zu jian le 。 DTS he qi ta shu ju dao ru dao chu fang shi zui da de bu tong jiu shi ta ke yi zai chu li shu ju de guo cheng zhong dui mei yi xing shu ju jin xing shen du chu li 。 yi xia shi yi duan VBScript dai ma , zhe duan dai ma zai chu DTS li mei yi tiao ji lu shi zhi xing ,DTSDestination biao shi mu biao ji lu ,DTSSource biao shi yuan ji lu , zai chu li “ hun yin zhuang kuang ” shi , jiang yuan ji lu zhong de “ hun yin zhuang kuang ” zhong de 0 huo 1 zhuan huan cheng mu biao ji lu zhong “ yi hun ” huo “ wei hun ”。 Function Main() DTSDestination(" xing ming ") = DTSSource(" xing ming ") DTSDestination(" nian ling ") = DTSSource(" nian ling ") If DTSDestination(" hun yin zhuang kuang ") = 1 Then DTSDestination(" hun yin zhuang kuang ") = " yi hun " Else DTSDestination(" hun yin zhuang kuang ") = " wei hun " End If Main = DTSTransformStat_OK End Function shang shu de san zhong shu ju dao ru dao chu fang fa ge you qi li bi , ta men zhi jian de xiang hu bi jiao ru tu 1 ru shi 。 <>B er 、 xing neng de bi jiao shi yong Transact-SQL fang shi 。 ru guo shi SQL Server shu ju ku zhi jian de dao ru dao chu , su du jiang fei chang kuai , dan shi shi yong OPENDATASOURCE he OPENROWSET fang fa li yong OLE DB Provider da kai bing cao zuo shu ju ku shi su du hui man yi xie 。 shi yong BCP ming ling fang shi 。 ru guo bu xu yao dui shu ju jin xing yan zheng deng cao zuo de hua , shi yong ta huan shi fei chang kuai de , zhe shi yin wei ta de nei bu shi yong c jie kou de DB-library, suo yi zai cao zuo shu ju ku shi su du you hen da de ti sheng 。 shi yong DTS fang shi dao shu ju ying gai shi zui hao de fang shi le 。 you yu ta zheng he le Microsoft Universal Data Access ji shu yu Microsoft ActiveX ji shu , yin ci bu jin ke yi ling huo di chu li shu ju , er qie zai shu ju dao ru dao chu de xiao lv shi fei chang gao de 。 zong jie SQL Server ti gong le feng fu de shu ju dao ru dao chu fang fa , zhe gei wo men ti gong le geng duo de xuan ze , dan shi zhe you hui gei wo men dai lai yi ge xin wen ti : ru he gen ju ju ti qing kuang xuan ze he shi de shu ju dao ru dao chu fang fa ne ? wo zai zhe li ti gong yi xie ge ren de jian yi , xi wang neng dui du zhe qi dao yi ding de zhi dao zuo yong 。 ru guo shi zai SQL Server shu ju ku zhi jian jin xing shu ju dao ru dao chu shi , bing qie bu xu yao dui shu ju jin xing fu duo de jian yan , zui hao shi yong Transact-SQL fang fa jin xing chu li , yin wei zai SQL Server shu ju ku zhi jian jin xing shu ju cao zuo shi ,SQL shi fei chang kuai de 。 dang ran , ru guo yao jin xing fu duo de cao zuo , ru shu ju jian yan 、 zhuan huan deng cao zuo shi , zui hao huan shi shi yong DTS jin xing chu li , yin wei DTS bu guang dao shu ju xiao lv gao , er qie neng gou dui shu ju jin xing shen du kong zhi 。 dan shi DTS de bian cheng jie kou shi ji yu com de , bing qie zhe ge jie kou shi fen fu duo , yin ci , shi yong cheng xu tiao yong DTS jiang bian ye hui bian de hen fu duo , yin ci , dang shu ju liang bu shi hen da , bing qie xiang jiang shu ju dao ru dao chu gong neng jia ru dao cheng xu zhong , er qie mei you fu duo de shu ju chu li gong neng shi , ke yi shi yong OPENDATASOURCE huo OPENROWSET jin xing chu li 。 BCP ming ling bing bu tai shi he tong guo cheng xu lai tiao yong , ru guo xu yao shi yong pi liang de fang shi dao shu ju , ke yi tong guo pi chu li wen jian tiao yong BCP ming ling , zhe yang zuo ji bu xu yao bian xie da liang de cheng xu , ye wu xu zai qi ye guan li qi zhong tong guo ge zhong cao zuo jie mian de qie huan lai jin xing shu ju dao ru dao chu 。 yin ci , ta bi jiao shi he zai ke hu duan wei an qi ye guan li qi huo shi yong SQL Server Express shi dui shu ju jin xing kuai su dao ru dao chu de chang he 。
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
可爱车模崔星儿(17)
可爱车模崔星儿(16)
可爱车模崔星儿(15)
可爱车模崔星儿(14)
艳丽的海棠花
钓者
南半球的天空--天涯海角
雪之界
 
>>返回首页<<
 为你推荐
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
©2005- 王朝网络 版权所有