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

sql server 2008 sql serverÉí·ÝÑéÖ¤ÎÊÌâ

ÎÒϵͳʽwin7 £¬Êý¾Ý¿âsqlserver2008.Ò»Ö±ÓÃwindowsÑéÖ¤£¬µÇ½£¬²»ÄÜÓÃsqlÑéÖ¤£¬ÔÚsaÉÏÖØÐÂ×¢²áÒ»¸öÓû§µÄ»°£¬µÇ½ʱµÚÒ»±é±¨
Òѳɹ¦Óë·þÎñÆ÷½¨Á¢Á¬½Ó£¬µ«ÊÇÔڵǼ¹ý³ÌÖз¢Éú´íÈ¡¡££¨provider:¹²ÏíÄÚ´æÌṩ³ÌÐò£¬error£º0-¹ÜµÀµÄÁíÒ»¶ËÉÏÎÞÈκνø³Ì¡££©£¨Microsoft SQL Server,´íÎó:233£©
È»ºóÔÙÊÔÒ»´Î¾Í°ü18456ÄǸö´íÎóÁË£¬
ÓÐÍøÉϽâ¾ö·½°¸Ëµ£¬°Ñ¡®MSSQLSERVERµÄЭÒ顯ϵġ°Named Pipes¡±ºÍ¡°TCP/IP¡±Æô¶¯¡£
ÎÒÒ²Æô¶¯ÁË£¬Ä¿Ç°»¹ÊDz»ÐУ¬Çë´ó¼ÒÖ¸½Ì¡£ÊDz»ÊÇÎÒ©ʲôϸ½ÚÎÊÌâ¡£
ûÓöµ½¹ý,°ï¶¥

ûÓùý,°ï¶¥.


Ïà¹ØÎÊ´ð£º

ÃÅÍ⺺ÇóÖú...¹ØÓÚºǫ́+SQL+ASP

....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷Ô­À´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......

Á½¸öµ¼¹¹sql serverÊý¾Ý¿â,Êý¾Ýµ¼Èëµ¼³öÎÊÌâ

ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß

µ¼Èëµ¼³ö¹¤¾ß.

DD

¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä

Ö±½ÓÐ ......

¾Ý˵SQLÓиö±à¼­Æ÷£¬²»ÖªÈçºÎʹÓ÷¨£¬ÔÚʲôµØ·½£¿

ÒªÊäÈëUSE <Êý¾Ý¿âÃû>ʱ£¬ÒªÓõ½SQL±à¼­Æ÷£¬µ«²»ÖªµÀÔÚʲôµØ·½£¬¸ßÊÖ°ï°ïæѽ£¡

SQL2005  µã»÷ÓÒÉϽǵÄ--н¨²éѯ(N)

Êó標選擇Òª²é詢µÄ數據庫£¬È»á ......

SQL Óï¾ä¡£¡£ Çë½Ì¸ßÊÖ

ÏÈÀ´Ò»¸ö´íÎóÓï¾ä¡£¡£
select * from [aa] where a1 in (select max(a2),a1 from [aa]  group by a1 )


ÎÒ´óÌåÒâ˼£¬
¶Áȡһ¸öͳ¼ÆÏµÍ³ÖÐ ²»Öظ´µÄ IP °´ÕÕ ×îºóʱ¼äÅÅÐò£¬²¢ÏÔʾ³öËùÓÐ×ֶΡ£¡ ......

ÇóÒ»SQLÓï¾ä

ÎÒÏÖÔÚÓÐ2¸ö±íTable1£¬Table2¡£¶ÔÓ¦µÄ×ֶΡ¢Êý¾ÝÈçÏ£º

Table1£ºprimary key(a1)
a1(char)      a2(int)
  a            10
  b  & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ