SQLµÇ½ÎÊÌâ
ÇëÎÊÔڵǼʵÀýµÄʱºòÓÃlocalhost,(local),127.0.0.1ºÍ.ÓÐÊ²Ã´Çø±ð¡£
·Ö±ðÓÃÕâЩµÇ½µÄʱºòÒªÈçºÎÅäÖÃSQL Server Configure ManagerÀïµÄserverºÍnativeClientµÄÐÒé
localhost,(local),127.0.0.1ºÍ.¶¼´ú±í±¾µØ·þÎñÆ÷ ¿ÉÒÔ˵ÊǼ¸ÖÖ²»Í¬µÄд·¨¶øÒÑ
127.0.0.1ÊÇÄãÒÔÄã¸öÈË»úÆ÷Ϊ¾ÖÓòÍøµÄIPµØÖ·£¬¶ølocalhostÔò¾ÍÊÇÄã»úÆ÷µÄ±ðÃû¡£
Â¥ÉÏÕý½â
µ«ÊÇÎÒÔÚSQL Server Configure ManagerÀï°ÑserverºÍnativeClientµÄpipeºÍTCP/IPÐÒ鶼ͣÓÃÁË ÎªÊ²Ã´»¹ÊÇÄÜͨ¹ýlocalhostºÍlocalµÇ½£¿
¶øÇÒÓÃlocalµÇ½¿ÉÒÔʹÓÃsa¶øÓÃlocalhostµÇ½ֻÄÜͨ¹ýwindowsÉí·ÝÑéÖ¤µÇ½ ÕâÊÇΪʲô£¿£¿£¿
ÎÒ¸öÈ˸оõûÓÐÊ²Ã´Çø±ð,²»¹ýÔÚÓÃÓï¾äÁ¬½Óʱһ°ã¶¼ÊÇÓÃlocalhostµÄ±È½Ï¶à.
±¾»úµÇ¼ÊÇͨ¹ýshare memory
Èç¹ûÁ¬½Ó×Ö·û´®ÖУ¬Ã»ÓÐÖ¸¶¨ network library£¬
Ôò Data Source Ϊ (local), localhost, . ʱ£¬Á¬½Ó¶¼Ê¹Óá°¹²ÏíÄڴ桱ÐÒ飬
Data Source Ϊ 127.0.0.1 ʱ£¬Á¬½ÓʹÓá°tcp/ip¡±ÐÒé¡£
lz ¿ÉÒÔͨ¹ý select session_id, net_transport from sys.dm_exec_connections where session_id=@@spid ÑéÖ¤¡£
µÇ¼ÀïÒ²ÓÐѧÎÊ£¬Ñ§Ï°¡£
ÔÚSQL ServerÖУ¬ÊǰÑÍøÂçÐÒéNamed pipesºÍTCP/IP³ÉΪÐÅÈÎÐÒ飬Õâʱ¾Í¿ÉÒÔʹÓÃwindowsÑéÖ¤£¬Ò²¿ÉÒÔʹÓÃSQL ServerÑéÖ¤¡£
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ôºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......
Êý¾Ý¿âÒªÔõôѧ²Å²»»áÏԵóéÏó°¡£¿
Õâ¾ÍÒª¿´ÄãÊʺÏʲô·½·¨ÁË£¬Õâ¾ßÌå²»ºÃ˵µÄ.....
ÔõôÁË£¬ÄѵÀ´ó¼Ò¶¼²»»á£¬»¹ÊÇÕæµÄÌ«³éÏó´ó¼Ò²»ÖªµÀÔõô˵°¡
½áºÏÄã²Ù×÷Êý¾Ý¿âµÄÌå»áºÍÀí½â£¬Ó¦¸ÃЧ¹û»á¸üºÃ¡£·ñÔò£¬Ò ......
<table style="width: 1000px"><tr>
<td style="height: 38px; width: 35px;">
ÐÕÃû</td>
......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......