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

sql²éѯÎÊÌâ

²»ÖªµÀÎÒÃèÊöÇå³þÁËÂð£¬ÎÒÏÖÔÚÊÇÏëÒªÓÃÒ»¸ösqlÓï¾äʵÏÖÕâÑùµÄ¹¦ÄÜ£¬ÇëÎÊ¿ÉÒÔÂð£¬ÓÐûÓиüºÃµÄ°ì·¨À´ÊµÏÖ£¿
лл´ó¼ÒÁË
ʲô¹¦ÄÜ£¿

ÔÎ,

..

ΪʲôÎÒÃèÊöµÄÎÊÌâ·¢±í²»ÁË£¬×Ü˵ÓзǷ¨´Ê»ò´Ê×飬ÎÒ²éÁËÏÂûÓÐʲôÒ쳣ѽÔΰ¡

ÒýÓÃ
ΪʲôÎÒÃèÊöµÄÎÊÌâ·¢±í²»ÁË£¬×Ü˵ÓзǷ¨´Ê»ò´Ê×飬ÎÒ²éÁËÏÂûÓÐʲôÒ쳣ѽÔΰ¡
¿ÉÄܸÕÉýÍê¼¶ÄØ,Í·Ïñ¶¼¿´²»µ½ÒÔǰµÄÁË


Ïà¹ØÎÊ´ð£º

ÈçºÎÓÃc#£¬sql2000 ¿ª·¢c/sÏµĹ¤×÷Á÷£¿

±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......

ÇóÒ»SQLÓï¾ä

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

Table1£ºprimary key(a1)
a1(char)      a2(int)
  a            10
  b  & ......

ÇóSQLÓï¾ä

ÏÖÔÚÓÐÁ½Õűí
a±íºÍb±í

a±í:
¹¤ºÅ  ÐÕÃû  ËùÊô²¿ÃűàºÅ
001              A
002              B
003&n ......

sql server browserºÍsql server sql server express

sql server browserºÍsql server sql server expressÊǸÉÂðµÄ
ÎÒÖ»ÊÇÓÃSQL2005×öÍøÕ¾Êý¾Ý¿â£¬ÇëÎÊ¿ÉÒÔ½ûÓÃÂð£¿
ÎÒÏë½ÚÔ¼·þÎñÆ÷×ÊÔ´
»¹ÓÐÒ»¸ösql server fill text search
Õâ¸öÓ¦¸ÃÊÇÈ«ÎÄËÑË÷°É£¬¿ÉÒÔÒ²¿ÉÒ ......

sql ±¯¾ç

http://topic.csdn.net/u/20091008/12/a2577eba-1b5b-4e1e-ab20-0a047bf3f8d7.html?4385
1Â¥
liangCK
SQL code:
update a set
ʱ¼ä = b.ʱ¼ä
from tb1 as a
join tb2 as b
on a.¿¨ºÅ= b.¿¨ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ