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

SQLÔ¶³ÌÁ¬½ÓÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÎÒÔÚ±¾»úÁ¬½ÓÊý¾Ý¿âÔËÐгÌÐòûÓÐÎÊÌâ,¿ÉÊÇÎҰѳÌÐò¸ÄΪÁ¬½ÓÔ¶³Ì·þÎñÆ÷ÔËÐоͳöÏÖ((ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: ÃüÃû¹ÜµÀÌṩ³ÌÐò, error: 40 - ÎÞ·¨´ò¿ªµ½ SQL Server µÄÁ¬½Ó) ))Õâ¸ö´íÎó!ÎÒÓõÄÊÇsql2005 EXPRESS£¬ÎÒÒѾ­°´ÕÕÍøÉÏ˵µÄÆôÓÃSQLServer ä¯ÀÀÆ÷·þÎñÁË£¬»¹ÊÇͬÑùµÄÎÊÌ⣡£¡£¡£¡
ÔõôûÈË°¡£¿Ç§ÍòÒª°ï°ïæ°¡£¡£¡£¡¶¥Ò»ÏÂ

ÅäÖùÜÀí¹¤¾ß-¡·SQL Server ÍâΧӦÓÃÅäÖÃÆ÷-¡··þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷-¡·Database Engine-¡·Ô¶³ÌÁ¬½Ó-¡·Ñ¡ÖС®±¾µØÁ¬½ÓºÍÔ¶³ÌÁ¬½Ó¡¯-¡·ÖØÆô·þÎñ¡£ ÓÐ×ö¹ýÉÏÊöµÄÅäÖÃÂð£¿

Did you enable remote connection for TCP and Named Pipe?

Look under SQL Server 2005 Surface Area Configuration for Services and Connections -> Instance Name -> Database Engine -> Remote Connection

ÖØÆô¹ý£¬¿É¾ÍÊÇûÓã¬ÎÒÊÇ°´ÕÕÕâ¸öÉÏÃæ×öµÄhttp://wanjianfei.javaeye.com/blog/439658£¬ÇÒ·À»ðǽҲ¹ØÁË£¬ÐéÄâ·þÎñÆ÷ÓõÄÊÇ»¨Éú¿Ç;Ôõô°ì°¡£¿ºÜÓôÃÆ


ÒýÓÃ
ÖØÆô¹ý£¬¿É¾ÍÊÇûÓã¬ÎÒÊÇ°´ÕÕÕâ¸öÉÏÃæ×öµÄhttp://wanjianfei.javaeye.com/blog/439658£¬ÇÒ·À»ðǽҲ¹ØÁË£¬ÐéÄâ·þÎñÆ÷ÓõÄÊÇ»¨Éú¿Ç;Ôõô°ì°¡£¿ºÜÓôÃÆ


Firstly, are you sure your SQL Server is running on the port you expect it to. Check out this post http://topic.csdn.net/u/20100520/16/6cf306aa-e2d5-423b-94fb-2a6f4694d908.html

ÒѾ­¿ªÁËÕâ¸ö1433¶Ë¿Ú£¬ÔËÐÐ->cmd->netstat –ano ÖÐÏÔʾÓÐTCP 0.0.0.0:1433 0.0.0.0:0 LISTENING 440

ÎÒµÄÁ¬½Ó×Ö·û


Ïà¹ØÎÊ´ð£º

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......

Ò»Ìõ SQL - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÐÕâÑùÒ»ÌõSQL
 Select Get_Costtaxrate(col1), Get_Tcostvalue(col1) from a
 
ÆäÖÐGet_Costtaxrate¡¢Get_Tcostvalue¶¼ÊǺ¯Êý£¬ÕâÁ½¸öº¯ÊýÀïÃ涼ÊDzéÕÒÒ»¸ö´ó±í£¬Get_Tcostvalue»¹ÐèÒªµ÷ÓÃGet_C ......

¹ØÓÚSQLÓï¾äORµÄÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
......

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ - MS-SQL Server / »ù´¡Àà

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ

¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿

Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ

º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£

sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......

asp wap sqlÓï¾äÖлñÈ¡µÄºº×Ö²»ºÃÊ - Web ¿ª·¢ / ASP

SQL code:

rs.open "select * from guide where city_name='±±¾©' order by pai desc",conn,1,1
do while not rs.eof or rs.bof
¡£¡£
¡£¡£
¡£¡£
rs.movenext
loop
Õâ¸ösqlÓï¾äÔÚwapÕ¾Àï ±¾ÉíÓÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ