Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ :

[sql] update select ÎÊÌâ

tb_a ±í ÓУº

mobile  varchar(20),
fee  money£¬
.......


tb_b±í ÓУº
mobile  varchar(20),
fee  money£¬

ʵÏÖ£¬tb_a ÖÐÈç¹û mobile ÔÚtb_b±íÖУ¬ÔòÐÞ¸ÄfeeֵΪtb_b±íÖжÔÓÚfeeµÄÖµ


ɶÒâ˼???

»Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡  »Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡&n ......

Çë½ÌÕâÑùµÄSQLÔõôд

±í:
group    value
1        1
1        2
1        3
2        1
2        3
3        1
3        3

ÿһ×éÖÐ(id)ȡһ¸öÖµ, ......

SQL ServerÎÞ·¨Í¨¹ýIPµØÖ·×¢²á·þÎñÆ÷¼°Á¬½Ó

ÈçÌ⣬¹À¼Æ¿ÉÄÜÊDz¡¶¾º¦µÄ£¬³ýÁËɱ¶¾£¬»¹ÓÐʲôºÃµÄ½â¾ö°ì·¨£¿

´ò¿ªÁË£¬ÓÃÃû³Æ¿ÉÒÔ×¢²á¡£

´ÓÄã±¾»útelnetÔ¶³ÌµÄÊý¾Ý¿â¶Ë¿Ú ͨÂð£¿

ÔÚHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectToϽ¨Á¢Á½¸ö×Ö·û´®Öµ£º
    1¡¢ÊýÖµÃû³Æ£ºipµØÖ·£¨Óû§×ÔÐÐÐ޸ģ¬ÎÞÐè¶Ë¿ÚºÅ£©
    ......

ÿÌìȡǰ10Ãû ÕâÑùµÄsqlÔõôд

¼ÙÉèÓÐÕâÑùÒ»Õűí 
create table test_db (
  id number,
  name varchar2(10),
  count number,
  logdate date
)
¼ÙÉèÓÐÕâЩ¸öÊý¾Ý:
1,a1,1,2010-02-03
2,a2,2,2010-02-03
.................
10,a10,10,2010-02-03
11,a11,11,2010-02-03
..............
30,a3, ......

Óô¿C#дһ¸ö¹ÜÀíϵͳ¡¡²»ÓÃSQL - .NET¼¼Êõ / C#

Óô¿C#дһ¸öѧÉú¹ÜÀíϵͳ¡¡ 
½øÐÐÔöɾ¸Ä²é²¢ÇÒ¿ÉÒÔ±£´æ¡¡
²¢ÇÒÍ˳öºóÏ´λ¹ÓÐÉÏ´ÎÐ޸ĵÄÀàÈÝ
ÄǸö¡¡ÊÇÔõô×öµ½µÄ¡¡
ÊÇдÈçÎı¾È»ºó¶ÁÈ¡
»¹ÊÇÆäËüµÄ·½·¨?
¿É²»¿ÉÒÔ Ð½¨Ò»¸ö ѧÉú Àà 
È»ºóÔÚ Ð´Ò»Ð© ×Ö¶Î ±ÈÈç ÐÕÃû ÄêÁä µç»° µÈ
È»ºóÔÚ½øÐÐÐÞ¸Ä ¿ÉÊÇÔõôÑù ÄÜʵÏÖÍ˳öºó±£´æÄØ
»¹ÓÐ ÎÒÏë°ÑËüµÄ½çÃæ × ......

SQL SERVER±í×Ô¶¯Ôö³¤IDÎÊÌâ

ÎÒÓÐÒ»¸öÊý¾Ý¿â£¬ÀïÃæÓкöà±í£¬¶øÇÒ±íÀïÃæ¶¼ÊÇÓÐ×Ô¶¯Ôö³¤µÄIDÁУ¬ÏÖÔÚÎÒÏë°ÑÀïÃæµÄÊý¾Ý¶¼Çå¿Õ£¬È»ºóÈÃID´Ó1¿ªÊ¼¼ÆË㣨¾ÍÊÇÎÒÖØÐÂÔÙ²åÈëÊý¾Ýʱ£¬ID´Ó1¿ªÊ¼¼ÆË㣩£¬ÓÐʲô·½·¨Ã´£¿¼±£¡£¡

ÕâÑù¾ÍÒªÒÔ´Ó¿ªÊ¼¼ÆËãÁËô£¿Êý¾Ý¿â±¾ÉíÔ­À´µÄ´¥·¢Æ÷£¬´æ´¢¹ý³Ì»¹ÓÐЧÊÇô£¿

ÒýÓÃ
ÕâÑù¾ÍÒªÒÔ´Ó¿ªÊ¼¼ÆËãÁËô£¿Êý¾Ý¿â±¾ÉíÔ­À´µÄ´¥ ......
×ܼǼÊý:27572; ×ÜÒ³Êý:4596; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [1317] [1318] [1319] [1320] 1321 [1322] [1323] [1324] [1325] [1326]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ