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

access Êý¾ÝÈçºÎµ¼Èëµ½SQLÖÐ Çë¸ø³öÏêϸ¹ý³Ì

access Êý¾ÝÈçºÎµ¼Èëµ½SQLÖÐ Çë¸ø³öÏêϸ¹ý³Ì £¬Ð»Ð»
ÒýÓÃ
access Êý¾ÝÈçºÎµ¼Èëµ½SQLÖÐ Çë¸ø³öÏêϸ¹ý³Ì £¬Ð»Ð»

Èç¹ûÖ»Êǵ¼Êý¾Ý,ʹÓÃDTS»òSSISµ¼Èë¼´¿É,ûʲôÏêϸ¹ý³Ì,°´ÕÕ½çÃæÒ»²½Ò»²½×ß¼´¿É.

DTS ²»ÊÇÖ»Ö§³Ö Îı¾¸ñʽÂð£¿
ÁíÍâÄã˵µÃÎÒ¶¼²»ÖªµÀÔÚÄÄÀïÆô¶¯£¬ËùÒÔÇë¸ø³öÏêϸ¹ý³Ì£¬ÎҼǵÃÒÔÇ°ÓиöÍⲿ¹¤¾ßÄÜʵÏÖ£¬²»¹ýÏÖÔÚ¶àÄêûÓÃÁË£¬Ò²ÕÒ²»µ½ÁË¡£


ÒýÓÃ
DTS ²»ÊÇÖ»Ö§³Ö Îı¾¸ñʽÂð£¿
ÁíÍâÄã˵µÃÎÒ¶¼²»ÖªµÀÔÚÄÄÀïÆô¶¯£¬ËùÒÔÇë¸ø³öÏêϸ¹ý³Ì£¬ÎҼǵÃÒÔÇ°ÓиöÍⲿ¹¤¾ßÄÜʵÏÖ£¬²»¹ýÏÖÔÚ¶àÄêûÓÃÁË£¬Ò²ÕÒ²»µ½ÁË¡£



¾ÍÊǵ¼Èëµ¼³ö¹¤¾ß °²×°ÁËSQLÒÔºó¶¼ÓеÄ


dtsÊÇÒ»×鹤¾ßµÄ¼¯ºÏ °üÀ¨²»Í¬µÄÊý¾ÝÔ´Ö§³Ö Êý¾Ý²Ù×÷ ¾¯±¨ Á÷³Ì²Ù×÷ ÌáÐÑµÈ accessµ±È»Ò²ÊÇÊý¾ÝÔ´,dts¿ÉÒÔÖ§³Ö¼¸Ê®ÖÖ
ÎҼǵúܾÃÒÔÇ°¿´¹ýÒ»±¾sqlµÄÊé ×÷Õß˵Èç¹û΢Èí°Ñdtsµ¥¶ÀÄóöÀ´×öÈí¼þÂô ÏúÁ¿¿Ï¶¨±ÈsqlserverÒªºÃµÄ¶à


ÒýÓÃ
DTS ²»ÊÇÖ»Ö§³Ö Îı¾¸ñʽÂð£¿
ÁíÍâÄã˵µÃÎÒ¶¼²»ÖªµÀÔÚÄÄÀïÆô¶¯£¬ËùÒÔÇë¸ø³öÏêϸ¹ý³Ì£¬ÎҼǵÃÒÔÇ°ÓиöÍⲿ¹¤¾ßÄÜʵÏÖ£¬²»¹ýÏÖÔÚ¶àÄêûÓÃÁË£¬Ò²ÕÒ²»µ½ÁË¡£


¹¤¾ß--Ïòµ¼--Êý¾Ýת»»·þÎñ sql2000

ÎÒûÓùý Ҳû¿´µ½  ÔÚÄÄÀïÆô¶¯£¿

ÎÒÓõÄÊÇSQL2005  ÎÒÕÒÁËûÓÐÄãËù˵µÄ¹¤¾ß£¬ÎÒÒ²ÖØа²×°sql È«²¿°²×°£¬ÌáʾûÓÐÐèÒªÉý¼¶µÄ×é¼þ£¬ÄÄÀïÄÜÕÒµ½ÄØ

ÕÒµ½ÁË Ð»Ð» dawugui


Ïà¹ØÎÊ´ð£º

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ï棡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεĻ°¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

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

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

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ