MSSQL ת»» MYSQL
ÈçºÎ½«MSSQLÊý¾Ý¿âת»»ÎªMYSQL
ÔÚÍøÉÏÕÒÁ˺ܶà ˵µÄºÜÂÒ ÇëÎÊÓиßÊÖ¿ÉÒÔ½ÌÏÂÂð ллÁË
ûÓÐʲôºÃ°ì·¨¡£Á½ÕßÖ®¼ä»¹ÊÇÓÐЩ²îÒìµÄ¡£
Êý¾ÝÀàÐÍ£¬´æ´¢¹ý³ÌÓï·¨¡£
Èç¹ûÖ»ÊDZíºÍ¼Ç¼£¬Ôò¿ÉÒÔ°²×°Ò»¸öMYSQL µÄ£Ï£Ä£Â£ÃÔڣӣѣ̡¡£Ó£Å£Ò£Ö£Å£ÒÉÏ£¬È»ºó½«£Ó£Ñ£Ì¡¡£Ó£Å£Ò£Ö£Å£ÒÉϵÄÊý¾Ýµ¼Èëµ½£Í£Ù£Ó£Ñ£ÌÖС£
ÊÇµÄ ¾ÍÊÇΪÁËת±í¹ýÈ¥ °²×°ÁËODBCµ«ÊDz»»áÓÃ
ÓÃSQLSEVERµÄDTS
OR
½«SQLSERVERµÄ±íת»»³ÉTXTÔÙµ¼È룬
ÕâÊÇÁ½¸ö²»Í¬µÄÊý¾Ý¿â£¬×Ö¶ÎÀàÐÍ¡¢³¤¶ÈÓÐËùÇø±ð£¬ÌØÊâµÄ×ֶβ»Äܵ¼Èë
Ïà¹ØÎÊ´ð£º
¼ÙÉèÓÐÁ½ÕÅ±í£¬t1 t2
t1:id ×Ö¶Î1 ×Ö¶Î2 ×Ö¶Î3
t2:id ×Ö¶Î4 ×Ö¶Î5 ×Ö¶Î6
ÏÖÓÃÒ»Ìõ²éѯÓï¾äselect t1.*,t2.* from t1,t2 where t1.id=t2.id and Ìõ¼þ¡¡
½«·ûºÏÌõ¼þµÄÊý¾Ý´ÓmssqlÊý¾Ý¿âÖе¼³öÖÁexce ......
ÎÒÁ¬½ÓÁËÁ½¸öÊý¾Ý¿â£¬mssql£¬access
ÈçºÎÔÚͬһ¸ö°´Å¥Ï²Ù×÷Á½¸öÊý¾Ý¿âµÄ±í
±ÈÈ磬ÎÒͨ¹ý¸´ÔÓµÄsqlÓï¾ä´ÓmssqlÊý¾Ý¿â¶à¸ö±íÈ¡µÃÁËÊý¾Ý
È»ºó²åÈëaccessÊý¾Ý¿âijһ¸ö±íÖÐ
SQL code:
SQL SER ......
ÉÌÆ·±í
ProductManager_Name ProductManager_Type_Id
-------------------------------------------------------------
Öйú¾¼ÃÈȵãÑо¿ ......
ÇëÎÊ£ºÔÚ¶à±í²éѯÖУ¬²éѯ²»Í¬±íÖеĶà¸ö×ֶΣ¬ÆäÖÐÓÐЩ×ֶΰüÀ¨º¯Êý£¬¶àл¸÷λ´óÏÀÖ¸µãÃÔ½ò°¡£¡£¡£¡
±í1
¹¤ºÅ ÐÕÃû
1 Ëν
2 ¬¿¡Òå
± ......
´óϺÃÇ£¬ÎÒÏë×öÒ»¸öÍøÕ¾µÄºǫ́Êý¾Ý¿â£¬ÓÃMSSQL½øÐÐÉè¼Æ£¬ÍøÕ¾µÄÀàÐÍÀàËÆÓÚ¹ºÎïÍøÕ¾£¬ÄÇôÎҵĺǫ́Êý¾Ý¿âÓ¦¸ÃÔõÑùÉè¼ÆÄØ£¿£¿
ÓÐûÓÐÒ»¸ö±È½Ï³É¹¦µÄÊý¾Ý¿âµÄÉè¼ÆÀý×Ó¹²ÔÚÏÂÑо¿Ò»Ï£¿£¿¼±Óõģ¬ÔÚÏ ......