Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQL°æÍí¼äÐÂÎÅ

±¾½ÚÄ¿ÓÉ£º
±í½ã      ×ÔÐŵÄÅ®ÈË×îÃÀÀö
Ê÷¸ç      Ê®ÄêÊ÷ľ£¬°ÙÄêÊ÷ÈË
Ë®¸ç      ˮˮ¸ü½¡¿µ
ÁªºÏÔÞÖú²¥³ö
----------------------------------------------------------------------------------------------------
¹ÛÖÚÅóÓÑÍíÉϺ㬽ñÌìÊÇ2009Äê9ÔÂ9ºÅ£¬Å©ÀúÆßÔ¶þʮһ¡£»¶Ó­ÊÕ¿´Íí¼äÐÂÎÅ£¬ÎÒÊÇ¿¾Ñ¼
±¾Ê±¶ÎµÄÖ÷ÒªÄÚÈÝÓУº
¡¾°æÄÚÒªÎÅ¡¿
½Ìʦ½ÚÀ´ÁÙ£¬°æÄÚʦÉú´ò³ÉһƬ£¬Æø·ÕÈÈÁÒ¡¾ÐÂÎÅÁ´½Ó¡¿
ƦƦ·¢±í½ÚÈÕÑÝ˵¡¾ÐÂÎÅÁ´½Ó¡¿

¡¾ÓéÀÖ°ËØÔ¡¿
²Å¿¡ÇàÄê±íÑݼÆÊ±¾ø¼¼£¬ÈËÌåÄÖÖÓÊÇÔõÑùÁ¶³ÉµÄ£¿¡¾ÐÂÎÅÁ´½Ó¡¿
ÃÀÅ®¸ß¹Ù±»ÆØ°µÏä²Ù×÷£¬È¨Á¦ÓëÕýÒåÖ®ÕùË­½«Ð¦µ½×îºó£¿¡¾ÐÂÎÅÁ´½Ó¡¿
ÃÀòÄÐ×ÓÆµÆµ±»Í¬ÐÕÇ󰮣¬²»¿°É§ÈÅ¿¼ÂÇÕûÈÝ¡¾ÐÂÎÅÁ´½Ó¡¿
ȺÖÚÈÈÁÒÆÚÅιúÇì´ó¼Ù£¬ÓÐÈËÒÑ¿ªÊ¼ÌáǰÇì×£¡¾ÐÂÎÅÁ´½Ó¡¿
СÈýÉ¢·Ö£¬»ú»áÄѵò»ÈÝ´í¹ý¡¾ÐÂÎÅÁ´½Ó¡¿
----------------------------------------------------------------------------------------------------
¹ã¸æÍ¬Ñù¾«²Ê

С°®£ºÊ¦¸µÄãÔÚÄÄ£¿ÎÒÊÇÕæÐĵģ¡
ZS£ºÕ÷»é¡£ÒªÇó£ºÅ®µÄ£¬»îµÄ¡£
FC£ºÕ÷»é¡£ÒªÇ󣺳ÁÓãÂäÑã±ÕÔÂÐß»¨ÎÂÈá¶Ëׯ¡£·Ç³ÏÎðÈÅ¡£
±í½ã£º³ÁÓãÂäÑã±ÕÔÂÐß»¨ÎÂÈá¶ËׯÊÊÁäÅ®Ñý³ÏÕ÷ÌÆÉ®Ò»Ãû
С³æ:³ÏÕ÷ÊÊÁä´ÆÐÔС³æÒ»Ãû¹²¶ÈÓàÉú£¬ÒªÇó£ºÉ«ÔóÏÊÁÁ£¬ÅÀÐÐËÙ¶ÈÖеȣ¬ÉíÌ彡¿µÎÞÒìζ

----------------------------------------------------------------------------------------------------
»¶Ó­»ØÀ´
ÏÂÃæ¹Ø×¢Ò»ÏÂÃ÷ÌìµÄÌìÆø£º

Ã÷ÌìµÄÊÂÃ÷ÌìÔÙ˵

ÒÔÉϾÍÊDZ¾´ÎÐÂÎŵÄÈ«²¿


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

SQL ¶à±í²éѯ²é³öËùÒªµÄÊý¾Ý£¿

ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо­¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......

dbf±íµ¼Èëµ½sql server2000±íÎÊÌâ

ÇëÎÊ£º
1,ÈçºÎ½«Ò»ÕÅdbf±íµ¼Èëµ½sql server2000ÖеÄÒ»ÕÅ±í¡£Ê¹ÓÃDTS¸ÃÔõÑùʵÏÖ£¿
2,ʹÓÃÍøÉÏ´úÂ룺
Insert Into Tb_cj Select * from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro D ......

SQLÃÔ»ó

CREATE TABLE [Test_xcmtmp] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[subject] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Sourc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ