mssqlµÄipÔõô²é
ÎÒÔÚ±¾µØ°²×°ÁËmssql,µÚÒ»´Î°²×°²»³É¹¦,ÎÒɾÁËÖØÐ°²×°ÁËÒ»´Î,³É¹¦ÁË,¿ÉÊÇÈç¹ûÒªÁ¬½ÓPC-200911091809\A123456712345671³ÉÁËÕâÑù,Õâ ÊÇÔõô»ØÊÂ,ÄÇÎÒ±¾µØµÄmssql µÄipÊÇʲô°¡?
¾ÍÊÇÄã»úÆ÷µÄip°¡
¿ªÊ¼-ÔËÐÐ-cmd £º ipconfig
......127.0.0.1
¿ªÊ¼---ÔËÐÐ---ipconfig/all
.
Õâ¸öʵÀýÃûÄܲ»ÄÜ»»µÄ°¡.
ÎÒphpÁ¬²»ÉÏÕâ¸öʵÀýÃû,
ÔõôÓÃaspÐеİ¡?
¸ü¸Ä¼ÆËã»úÃû,Ò²¿ÉÄÜÂé·³,ÖØ×°Ò»´ÎßÂ
֨װºÃÂé·³°¡,,,,,,,,,,,,
ÔÚ±¾»úÁ¬½Ó£¬IP¿ÉÒÔÓÃ127.0.0.1
ipconfig²é±¾»úIP,ÖÁÓÚÄãphpÁ¬½Ó²»ÉÏÕâºÜ¿ÉÄÜÊÇÄãÁ¬½ÓµÄÎÊÌâ,û±ØÒª²»ÖªµÀÔÒò¾Í֨װ,ÏȸãÇå³þʲôÔÒòÔÙ˵
Èç¹û±¾»úµÄ»°£¬Ö±½ÓʹÓÃ. ¾Í¿ÉÒÔÁË£¬µã·ûºÅ¾Í´ú±í±¾»ú
ÕâЩÎÒ¶®,ÏÖÔÚÎÒ֨װmssql½â¾öÁË,ÓôÃÆ²»»ámssqlÕâ¶«Î÷.»¹ÒªÏòÄãÃÇѧϰ.
ʵÀý²»Í¬£¬Ä¬ÈÏʵÀýÊǼÆËã»úÃû³Æ
Ïà¹ØÎÊ´ð£º
ÎÒÉè¼ÆµÄ
Óû§ÐÅÏ¢±í ³±íÊý¾Ý±í ÀúÊ·³±íÊý¾Ý±í
ÎÒµÄÏë·¨ÊÇ Ã¿Ô³õ ϵͳ×Ô¶¯ÔÚ ³±íÊý¾Ý±íÖÐÉú²ú ÓëÓû§¹ØÁªµÄÊý¾Ý ÓÃÓÚ³±íÔ±µÄ¼È룬µ±³±íԱȫ²¿Â¼Èëºó °ÑÊý¾ÝÈ«²¿¸´ÖƵ½ÀúÊ·±íÖРͨʱ ......
mssqlµÄ´æ´¢¹ý³ÌÀïÔõô»ñµÃÒ»ÌõSQLÓï¾äµÄÖ´ÐÐ״̬Êdzɹ¦»¹ÊÇʧ°Ü£¿ÎÒÏëÔÚÒ»ÕűíÖÐÔö¼Ó¼Ç¼£¬Ê×ÏÈÒª¼ì²éÊÇ·ñÒѾ´æÔÚÏàͬ¼Ç¼£¬Èç¹û´æÔھ͸üУ¬·ñÔò¾Í²åÈë¡£
ÎÒ¾ÍÏëÏÈÊÔÊÔ²åÈë²Ù×÷£¬Ê§°ÜÁ˾ÍÈ¥¸üУ¬»òÕßÏÈÈ¥¸üР......
±¾ÈËÕýÔÚѧmssql£¬¸Õ¿´µ½´æ´¢¹ý³Ì£¬ÓÐЩ²»Ã÷°×£¬Çë´ïÈ˰ѷ±ÔӵĶ«Î÷£¬¼òµ¥»¯£¬ÐÎÏ󻯸øÎÒ½²½²£¬´æ´¢¹ý³ÌÔõôÓã¬Ã²ËÆ´æ´¢¹ý³ÌµÄ´úÂë·Åµ½²éѯ·ÖÎöÆ÷£¬µãÏÂÖ´ÐпÉÒÔ²Ù×÷£¬µ«ÊÇÆ½Ê±¶¼ÕâÑùÓÃô£¬ÄÜ×Ô¶¯µ÷ ......
Á½ÕÅ±í½¨Á¢Á˸üм¶Áª¹ØÏµ£¬µ«Ã»×öɾ³ý¼¶Áª£¬ÏÖÔÚɾ²»µôÊý¾ÝÁË£¬Ôõô°ì£¿×îºÃÊDz»¸Ä±ä±í½á¹¹µÄ~~~
¸÷λ´óϺ°ï°ïæ°¡~~
´¥·¢Æ÷
´´½¨¸öɾ³ý´¥·¢Æ÷
Õâô¿ì¾ÍÓÐÈË´ðÀ²~~¸Ð¶¯¡£¡£¡£Ð»Ð»
µ«ÒòΪÓÐ50¸ö·þÎñÆ÷Ô ......
¼ÙÉèÓÐÁ½ÕÅ±í£¬t1 t2
t1:id ×Ö¶Î1 ×Ö¶Î2 ×Ö¶Î3
t2:id ×Ö¶Î4 ×Ö¶Î5 ×Ö¶Î6
ÏÖÓÃÒ»Ìõ²éѯÓï¾äselect t1.*,t2.* from t1,t2 where t1.id=t2.id and Ìõ¼þ¡¡
½«·ûºÏÌõ¼þµÄÊý¾Ý´ÓmssqlÊý¾Ý¿âÖе¼³öÖÁexce ......