Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ö¾Ùsqlserver ÉϽ¨Á¢µÄÁ´½Ó·þÎñÆ÷Áбí

ÎÊÌâÊÇÕâÑùµÄ£¬
Îҵı¾µØsqlserver 2000 ·þÎñÆ÷ÉÏ£¬½¨Á¢Á˶à¸öÔ¶³ÌÁ´½Ó·þÎñÆ÷£¬
ÇëÎÊ£¬ÎÒÈçºÎͨ¹ý sqlÓï¾ä£¬»òÕ߯äËûµÄ·½·¨Ã¶¾Ù ÕâЩÁ´½Ó·þÎñÆ÷ÄØ£¿£¨Í¨¹ýÆóÒµ¹ÜÀíÆ÷ÎÒÊÇÖªµÀµÄ£¬
ÎÒÒªµÄÊÇÄÜͨ¹ý±à³Ìö¾Ùµ½ ......

ÇóÒ»sqlÓï¾ä¡£

±íÖÐÊÇÕâÑù£¬
²¿ÃźŠ   ²¿ÃÅÐÅÏ¢
  1        ²¿ÃÅÒ»
  2        ²¿ÃŶþ
  3        ²¿ÃÅÈý
  4& ......

sql server 2005 Ææ¹ÖµÄÎÊÌâ ¹ØÓÚÃû×ֵĶ¨Î»

sql server 2005 ´¥·¢Æ÷ Ö´ÐÐsp_executesql µÄÎÊÌâ
db1,db2ÊÇÒ»¸ö·þÎñÆ÷ server µÄ2¸öÊý¾Ý¿â

db1µÄtable1  ½¨Á¢Ò»¸öafter update´¥·¢Æ÷ ,µ± update  table1 ºó½¨Á¢Ò»¸ö¸´ÖÆ±íµ½  db2µÄtabl ......

access Êý¾Ý¿â SQLÓï¾äÔõôÑùËæ»úÑ¡ÔñÊý¾Ý£¿£¿

³ÌÐòʱASP+access

sql="select top 2 id,username from comp    order by rnd(id)  "

ÉÏÃæÓï¾äˢкó¶¼ÊÇÒ»¸öÖµ ÕâÑù»¹ÓÐËæ»úµÄÒâÒåÂð

ACCESSÓÐË¢ÐÂËæ»úÑ¡ÔñµÄSQLÓ ......

ÇóÒ»SQLÓï¾ä¡£Ð»Ð»

id    name    sfz

1    aa    410654198001204562
2    bb    410654198120461287
4    cc    41065419850 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ