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

Ôõô°Ñmysqlת³Ésql server

ÏÖÔÚÓÐmySqlµÄºó׺ÃûΪsqlµÄºÃ¶àÎļþ£¬ÎļþÀïÄÚÈÝ¿´²»Ì«¶®£¬µ«ÊÇÄÜ¿´¶®µÄÊÇÿ¸öÎļþÀï¶¼ÊÇÓбí½á¹¹ºÍÕâ¸ö±íµÄÊý¾ÝµÄ¡­¡­
ÏÖÔÚÏë°ÑÕâÑùµÄÎļþµ¼Èëµ½sql05ÖÐÈ¥£¬¶øÇÒÏÖÔÚÔÚ05ÀïÒѾ­°ÑÓÐЩ±í½¨³öÀ´ÁË£¬µ«Á½¸öÊý¾Ý¿â¶ÔÓÚͬһÕűíµÄ½á¹¹¿ÉÄܲ»Ò»Ñù£¨ÒòΪÊÇÁ½¸öÈË×öµÄ£©£¬Äܲ»ÄÜÔÚµ¼ÈëµÄʱºò¶ÔMyÀïµÄ×Ö¶ÎÓÐÑ¡ÔñÐԵĵ¼Èëµ½SQLÀïÄØ£¿£¿

¶øÇÒ×îÖØÒªµÄ£¬ÏÖÔÚ»úÆ÷ÉÏûÓÐMySql £¬ÎÒÖ»ÓÐÎļþ
Ö»ÓÐÊÖ¶¯À´¸ÄÁË  Ã²ËÆÃ»Ê²Ã´°ì·¨



Χ¹Û

SQL code:
SELECT REPLACE('mysql','mysql','sql server')


ÓÐMysqlµÄ¿âÂð£¿
»¹ÊÇ×°ÉÏMysql£¬È»ºóÀûÓõ¼Èëµ¼³öÊý¾ÝÉèÖÃÒ»ÏÂ×ֶζÔÓ¦£¬È»ºóÔÙµ¼°É¡£

¿´¿´±í½á¹¹ÊÔ×Å×Ô¼º½¨³ÉSQLSERVER°É£¡


ÈçÐèÒªÔĶÁ¸Ã»Ø¸´£¬ÇëµÇ¼»ò×¢²áCSDN!




Ïà¹ØÎÊ´ð£º

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

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°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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. 
¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ