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

SQL SeverºÍMySql - MS-SQL Server / »ù´¡Àà

sql serverµÄmdfÎļþÈçºÎÄܵ¼Èëµ½mysqlÖУ¬ÎÒÏëÁ˽âһϣ¬Ï£ÍûÅóÓÑÃǰïæ
·þÎñÆ÷Á¬½Ó,Ö±½Óµ¼ÈëÊý¾Ý

ÄÜ˵¾ßÌåµãÂ𣿱¾È˸սӴ¥£¬²»ÔõôÃ÷°×£¬Ð»Ð»ÁË

Ïȸ½¼ÓÔÚSQLºó£¬È»ºóÔٲο¼ÒÔÏÂ×ÊÁÏ£º

¡¡¡¡´Ósqlµ¼³öµ½mysqlµÄ·½·¨ºÜ¶à£¬ÏÖ½éÉÜÒ»ÖÖÎÞÐè±à³Ì£¬Ö±½ÓÀûÓÃsqlºÍmysqlÀïµÄͼÐνçÃæ½øÐе¼Èëµ¼³öµÄ¼òµ¥·½·¨¡£
¡¡¡¡¡¡¡¡ 
¡¡¡¡Ç°ÌáÊÇÒѾ­°²×°ÁËsqlserver¿Í»§¶ËºÍmysqlµÄͼÐνçÃæ¹ÜÀí¹¤¾ßphpmyadmin¡£
¡¡¡¡¡¡¡¡ 
¡¡¡¡ÔÚ¿ØÖÆÌ¨¸ùĿ¼Ï´ò¿ªsqlserverÆóÒµ¹ÜÀíÆ÷£¬Ð½¨sqlserver×飬¸ù¾Ý×Ô¼ºµÄÇé¿ö½øÐÐÑ¡Ôñ£»È»ºóн¨sqlserver ×¢²á£¬½øÐжÔsqlserverµÄÁ¬½Ó¡£×¼±¸Í×µ±ºó£¬ÏÂÃæ¾Í¿ªÊ¼ÁË£º
¡¡¡¡¡¡¡¡ 
¡¡¡¡Ê×ÏÈ´ò¿ªÊý¾Ýת»»·þÎñ£¬Ð½¨°ü£¬´ò¿ªDTS½çÃæ£¬ÔÚÁ¬½ÓÖÐÑ¡ÔñÊý¾ÝÔ´½øÐÐÅäÖá£ÔÙÑ¡Ôñ½«Òª×ª»»µ½µÄÄ¿µÄÎļþ£¬ÕâÀïÎÒÑ¡µÄ Textfile(destination)£¬Ñ¡ÔñºÃÎļþµÄ´æ·ÅλÖÃÖ®ºó£¬ÎÒÃÇÀ´Ð½¨Ò»¸öÈÎÎñ¡£ÕâÀïÎÒÃÇֻѡÔñת»»Êý¾ÝÈÎÎñ£¬½«´øÓС°Ñ¡ÔñÔ´Á¬½Ó¡±¡°Ñ¡ÔñÄ¿µÄÁ¬½Ó¡±µÄÊó±ê·Ö±ðÑ¡ÖÐÊý¾ÝÔ´ºÍÄ¿µÄÖ®ºó£¬ÎÒÃǶÔÐÂÉú³ÉµÄÁ¬½Ó½øÐж¨Ò壬ÔÚÆäÊôÐÔÖн«Ô´£¬Ä¿µÄ£¬×ª»»ÒÀ´Î¶¨Òå¡£
¡¡¡¡
¡¡¡¡Ö´ÐÐÈÎÎñ£¬Ìáʾ³É¹¦¡£±£´æÈÎÎñ¡£È»ºóÔÚн¨µÄÈÎÎñÉϵ¼³öÊý¾Ý£¬ÓÐÏòµ¼Ìáʾ£¬ÆäÖÐÒ»ÏîÑ¡Ôñ¡°´ÓÔ´Êý¾Ý¿â¸´ÖƱíºÍÊÓͼ¡±¡£
¡¡¡¡
¡¡¡¡ÕâÒ»²½ÒѾ­°ÑÊý¾Ýµ¼³öµ½Ä¿µÄÎļþÖС£
¡¡¡¡¡¡¡¡ 
¡¡¡¡ÏÂÒ»²½ÔÚmysqlÖÐн¨±í£¬Ó뽫Ҫµ¼ÈëµÄ½á¹¹±£³ÖÒ»ÖÂʱ£¬Ö±½Óѡȡ¡°´ÓÎı¾ÎļþÖÐÌáÈ¡Êý¾Ý£¬²åÈëµ½Êý¾Ý±í£º¡±£¬½«Ñ¡ÏîÌíºÃºó£¬¡°·¢ËÍ¡±¾Í¿ÉÒÔÁË£¬ä¯ÀÀһϣ¬Êý¾ÝÒѵ¼ÈëÁË¡£ÈôÒªµ¼ÈëµÄ±íÒѾ­´æÔÚ£¬ÇÒÊôÐÔÃûÒ²²»Í¬£¬Õâʱ¾ÍÏȽ¨Ò»¸öÓëÒªµ¼ÈëµÄÊý¾ÝÏàͬ½á¹¹µÄ±í²¢µ¼ÈëÊý¾Ý£¨°´¸Õ²ÅµÄ½øÐоͿÉÒÔÁË£©£¬È»ºóÔÚmysqlÖе¼³ö¡°Êý¾ÝºÍ½á¹¹¡±£¬µÃµ½sqlÓï¾


Ïà¹ØÎÊ´ð£º

SQLÈçºÎÓÅ»¯ÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì   »·¾³ÊÇSQL2000Êý¾Ý¿â  
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
        Ñ­»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)  
        ......

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

PHP+MYSQLÊý¾Ý¼¯´¦Àí - PHP / »ù´¡±à³Ì

1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿
2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......

SQL server·Ö½âXML - MS-SQL Server / Ó¦ÓÃʵÀý

ÏÂÃæÊÇXML³õʼÎļþÄÚÈÝ
XML code:
<upd:Update xmlns:lar="http://schemas.microsoft.com/msus/2002/12/LogicalApplicabilityRules" xmlns:cmd="http://schemas.microsoft.com/msus/2002/12/Up ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ