³õ²½Ïë·¨£ºÓÃmysql±íµÄ²åÈë´¥·¢Æ÷ÖУ¬°ÑÕâÌõÊý¾Ýͬʱ²åÈëµ½ sql serverµÄÊý¾Ý±íÖУ¬ÊÇ·ñ¿ÉÐУ¿
Çó½â¾ö°ì·¨£¬Ð»Ð»~
¿ÉÐУ¬µ«²»ºÃ²Ù×÷
¿ÉÒÔ°¡£¬³ÌÐòÀïÃæÄãÁ½¸öÁ¬½Ó£¬Ò»¸ömssql¡£Ò»¸ömysql
Õâ¸öÎªÊ²Ã´ÄØ
¿ÉÒÔ£¬³ÌÐòµ±È»¿ÉÒÔ×öÁË£¡
ÒýÓÃ
¿ÉÒÔ£¬³ÌÐòµ±È»¿ÉÒÔ×öÁË£¡
ÎÒÊDz»Ïë¸Ä³ÌÐò£¬ÔÚmy sqlÖ ......
ÎÒÓöµ½Ò»¸öÕâÑùµÄÎÊÌ⣬ÐèÒª´Ómysql ÖжÁÊý¾Ý£¬È»ºóµ½Èëµ½sql server 2005, ¶øÇÒÊÇÿÌì¶¼Ö´ÐÐÕâÑùµÄ²Ù×÷£¬´ÓÈí¼þʵÏֵĽǶȣ¬ÎÒ´ó¸ÅÓ¦¸ÃÔõôÑùʵÏÖ°¡£¿
°ï¶¥
Ïȵ½SQLSERVER2005°ÑÊý¾ÝÏȵ½³Éexecl È»ºóµ¼ÈëMHSQL¾ÍºÃÁË£¡
http://topic.csdn.net/u/20090906/17/4ccfa793-ec98-4505-bda7-fe94b0d1000d.html?seed=164507 ......
ÏÖÔÚÓÐmySqlµÄºó׺ÃûΪsqlµÄºÃ¶àÎļþ£¬ÎļþÀïÄÚÈÝ¿´²»Ì«¶®£¬µ«ÊÇÄÜ¿´¶®µÄÊÇÿ¸öÎļþÀï¶¼ÊÇÓбí½á¹¹ºÍÕâ¸ö±íµÄÊý¾ÝµÄ¡¡
ÏÖÔÚÏë°ÑÕâÑùµÄÎļþµ¼Èëµ½sql05ÖÐÈ¥£¬¶øÇÒÏÖÔÚÔÚ05ÀïÒѾ°ÑÓÐЩ±í½¨³öÀ´ÁË£¬µ«Á½¸öÊý¾Ý¿â¶ÔÓÚͬһÕűíµÄ½á¹¹¿ÉÄܲ»Ò»Ñù£¨ÒòΪÊÇÁ½¸öÈË×öµÄ£©£¬Äܲ»ÄÜÔÚµ¼ÈëµÄʱºò¶ÔMyÀïµÄ×Ö¶ÎÓÐÑ¡ÔñÐԵĵ¼Èëµ½SQLÀï ......
Oracle £ºselect grbh from com.eway.vo.Zjxx zj where to_char(zj.jbsj,'yyyymm')='"+ sj + "'
ÆäÖÐ sjÊÇ×Ö·û´®²ÎÊý ÏÖÔÚÏë°ÑÉÏÃæµÄSQLÓï¾äת»»ÎªMysqlµÄ Ö÷ÒªÊÇʱ¼ä´«Èë ÒòΪ´«ÈëµÄÊÇ×Ö·û´® 200909 ¶øÊý¾Ý¿âÖÐÊÇ 2009-09-31 00£º00£º00 ËùÒÔÏë ......
sql server±íÊý¾ÝÈçºÎµ¼Èëµ½mysqlÖУ¿£¿
³ÌÐòÒ»ÌõÒ»ÌõµÄ²éѯsql serverÊý¾Ý£¬È»ºóinsertµ½mysqlÖУ¬Êý¾ÝÁ¿´ó£¬Ì«ÀË·Ñʱ¼ä£¬ÓиüºÃµÄ°ì·¨Ìá¸ßËÙ¶ÈÂ𣿣¿
¹¤¾ß°É,µ¼Èëµ¼³ö
sql server bcpµ¼³öµ½Îı¾Îļþ.
mysql load data infileµ¼Èë.
SQL code:
/*
±êÌ⣺SQL Server 2000 Á¬½Ómysql.
×÷Õߣº°®Ð¾ ......
ÈçºÎÄÜ»ñµÃmysqlÖлñµÃ×ÔÔöÖ÷¼üµÄ×î´óÐòÁкţ¿
±ÈÈç˵£ºÎÒÍùÊý¾Ý¿âÖвåÈëÒ»ÐУ¬Ö÷¼üÔö¼Óµ½ÁË10£¬È»ºóÎÒ°ÑÕâÐÐɾ³ýÁË£¬ÎÒÔõôÄܵõ½Ö÷¼üÁÐĿǰµÄ×î´óµÄÐòÁкţ¿
@@identityÊDz»ÊDz»ÐУ¿
SELECT MAX(IDD) from TB
ÒýÓÃ
SELECT MAX(IDD) from TB
ÎÒÒªµÃµ½µÄÊÇÖ÷¼üÁеÄ×î´óÐòÁкţ¬²»ÊÇ×î´óÖ÷¼üÖµ
±ÈÈçË ......