mssqlÊý¾ÝתÒƵ½mysql - PHP / »ù´¡±à³Ì
×î½ü¹«Ë¾»»Êý¾Ý¿â£¬mssql »» mysql ¡£´ó¼ÒÓÐʲôºÃµÄ·½·¨°¡£¡
²»ÓÃphpת»»£¬´æÔÚÊý¾ÝÄ£Ð͵ÄÎÊÌâ¡£±¾È˺ÜÏëÓÃphp£¬¿ÉÊÇmssqlÀ©Õ¹Ôõô¶¼¼ÓÔز»ÉÏ£¬¸ãÁËÒ»Ììû¸ãÃ÷°×£¡»·¾³ÊÇ£ºapache2.2.4£¬php5.3.2£¨°²×°³ÌÐò£¬extÀïÃæûÓÐmssql.dll)¡£
¶øÇÒÌý˵ÓÐÖ±½Óµ¼Èëµ¼³öµÄ¹¤¾ß£¬Ö»ÕÒµ½Á˸ömysql to mssql £¬²»ºÏÓá£
´ó¼Ò°ïæÏëÏë°ì·¨£¬Ð»Ð»£¡
°²×°°üÀïÃæûÓÐ php_mssql.dll ¶øÇÒphp.iniÒ²²»ÊÇÏñ´ÓÇ°°æ±¾ÄÇÑùÒ»ÅÅextensionÔÚÒ»ÆðÁË
ÔÀ´ÕæûÓÐ!
sql2005¿ÉÒÔÓÃhttp://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=ccdf728b-1ea0-48a8-a84a-5052214caad9
·ñÔò¾Í¸É´àÓÃaspдµ¼ÈëÀ²
http://www.xdowns.com/soft/38/110/2008/Soft_40560.html
DBConvert for MSSQL and MySQL 2.2.1ÂÌÃËÂÌÉ«°æ_MS SQLÓëMySQL¼äÊý¾Ýת»»¹¤¾ß
ÓÖ¿ìÓֺõØת»»ÄúµÄÊý¾Ý¿â£º´ÓMSSQLµ½MySQL
MS SQL to MySQL
MS SQL to MS SQL
MySQL to MS SQL
MySQL to MySQL
MySQL to MySQL Dump
MS SQL to MS SQL Dump
MySQL to MS SQL Dump
MS SQL to MySQL Dump
MS SQL to PHP s cript
MySQL to PHP s cript
лл ÎÒÕýÑо¿Õâ¸ö¹¤¾ßµÄʹÓ÷½·¨
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬Ôõôд¸öheadÍ·²¿ ÈÃÒ³Ã滺´æ1ÐÇÆÚ¡£
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
Äã°ÑÀïÃæµÄʱ¼ä£¬¸Ä³Éµ±Ç°Ê±¼ä¼ÓÉÏÒ»¸öÐÇÆÚ
¼ÇµÃҪת»»³Égmtʱ¼ä
ÎÒÕâÑùдµÄ ²»ÖªµÀÐв»ÐС£
Ò»¸öÐ ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......
ʹÓÃjavaÔÚwindows7 32λÏÂÁ¬½ÓMSSQL¡£
Á½Ì¨»úÆ÷£¬windows7 32룬ÔÚ¿ØÖÆÃæ°åÀïÃæÈ«²¿ÉèÖÃÓïÑÔºÍÇøÓòÑ¡Ïenglish-unitedstates
ΨһÇø±ðÖ»ÓÐÔÚ°²×°SQL server 2008µÄʱºò Ñ¡ÔñµÄ×Ö·û¼¯²»Ò»Ñù£¬
exec sp_helpsor ......
sp ³ÌÐò
delimiter //
create procedure ma()
begin
declare i int default 0;
while i<11 do
set i=i+1;
select i;
end while;
end //
delimiter ;
1+2+...+9+10
ΪʲôÕâ¸ö³ÌÐòÎÞ·¨ÊµÏÖÀÛ¼ÓЧ¹û
/ ......