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

mysqlµ¼Èëµ½sql server2000ÎÊÌâ

¿Í»§ÒÔǰµÄÊý¾Ý¿âΪmysql ÏÖÔÚеÄϵͳÓõÄÊÇsql server 2000 ¿Í»§Ö»¸øÁËmysql µ¼³öµÄ ".sql"Îļþ.ÎÒ¸ÃÈçºÎ°ÑËüµ¼Èëµ½sql server 2000
Ö»Óнű¾Îļþ??ÄÇ»¹ÊÇ×°¸öMYSQL È»ºóµ¼Èëµ½MYSQLÖÐ ÔÙÓÃSQL SERVERµÄDTSÀ´½â¾ö

ÒýÓÃ
¿Í»§ÒÔǰµÄÊý¾Ý¿âΪmysql ÏÖÔÚеÄϵͳÓõÄÊÇsql server 2000 ¿Í»§Ö»¸øÁËmysql µ¼³öµÄ ".sql"Îļþ.ÎÒ¸ÃÈçºÎ°ÑËüµ¼Èëµ½sql server 2000

¿Í»§Èç¹û¸øÄãµÄÊÇmysql Éú³ÉµÄmssqlÎļþ¾ÍºÃ°ìÁË£¬Èç¹û²»ÊÇ£¬¾Í±­¾ßÁË

ÒýÓÃ
Ö»Óнű¾Îļþ??ÄÇ»¹ÊÇ×°¸öMYSQL È»ºóµ¼Èëµ½MYSQLÖÐ ÔÙÓÃSQL SERVERµÄDTSÀ´½â¾ö

sql server 2000µÄdtsÈçºÎ²Ù×÷ѽ.ÎÒÔõôûÓÐÕÒµ½mysql ÕâÒ»Ïî

ÎÒµÄsqlÖ»µÄ¶ÔoracleµÄoledb.ÔõôûÓжÔmysqlµÄ?Äܲ»ÄÜÔÙÖ¸½ÌÒ»ÏÂѽ.¸ßÈË!


ллСF¿ÉÎÒ»¹ÊÇsql server2000


Ïà¹ØÎÊ´ð£º

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

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

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

Á½¾äSQL²¢Ò»¾ä,ÓÐÎÊÌâ. - MS-SQL Server / »ù´¡Àà

µÚÒ»¾ä:
select ht.gfdm,gfdm.gfmc,gfdm.lb ,sum(jh.htdj*jh.htsl)as je
from ht left join gfdm on ht.gfdm=gfdm.gfdm 
 join jh on ht.htbh=jh.hth 
and ht.htbh not like'del%' and ht. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ