Ôõô°Ñmysqlת³Ésql server
ÏÖÔÚÓÐmySqlµÄºó׺ÃûΪsqlµÄºÃ¶àÎļþ£¬ÎļþÀïÄÚÈÝ¿´²»Ì«¶®£¬µ«ÊÇÄÜ¿´¶®µÄÊÇÿ¸öÎļþÀï¶¼ÊÇÓбí½á¹¹ºÍÕâ¸ö±íµÄÊý¾ÝµÄ¡¡
ÏÖÔÚÏë°ÑÕâÑùµÄÎļþµ¼Èëµ½sql05ÖÐÈ¥£¬¶øÇÒÏÖÔÚÔÚ05ÀïÒѾ°ÑÓÐЩ±í½¨³öÀ´ÁË£¬µ«Á½¸öÊý¾Ý¿â¶ÔÓÚͬһÕűíµÄ½á¹¹¿ÉÄܲ»Ò»Ñù£¨ÒòΪÊÇÁ½¸öÈË×öµÄ£©£¬Äܲ»ÄÜÔÚµ¼ÈëµÄʱºò¶ÔMyÀïµÄ×Ö¶ÎÓÐÑ¡ÔñÐԵĵ¼Èëµ½SQLÀïÄØ£¿£¿
¶øÇÒ×îÖØÒªµÄ£¬ÏÖÔÚ»úÆ÷ÉÏûÓÐMySql £¬ÎÒÖ»ÓÐÎļþ
Ö»ÓÐÊÖ¶¯À´¸ÄÁË Ã²ËÆÃ»Ê²Ã´°ì·¨
Χ¹Û
SQL code:
SELECT REPLACE('mysql','mysql','sql server')
ÓÐMysqlµÄ¿âÂð£¿
»¹ÊÇ×°ÉÏMysql£¬È»ºóÀûÓõ¼Èëµ¼³öÊý¾ÝÉèÖÃÒ»ÏÂ×ֶζÔÓ¦£¬È»ºóÔÙµ¼°É¡£
¿´¿´±í½á¹¹ÊÔ×Å×Ô¼º½¨³ÉSQLSERVER°É£¡
ÈçÐèÒªÔĶÁ¸Ã»Ø¸´£¬ÇëµÇ¼»ò×¢²áCSDN!
Ïà¹ØÎÊ´ð£º
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
ÎÒÏÖÔÚѧϰMYSQL£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл
½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£
http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
¿ÉÊÇÎÒÕÒ ......