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

ÇóÖú£ºSQLÓï¾ä

±í1£º
col1              col2
a                a.1
b                b.1
-------------------------
±í2£º
col1           
a(001)
a(002)
a(003)
...
b(001)
b(002)
b(003)
...
-------------------------
ÓÉÉÏÃæÁ½±í£¬ÈçºÎ¸ù¾ÝSQLÓï¾ä°ÑÔ­Óеıí1¸Ä³ÉÈçϱí
Ð޸ĺóµÄ±í1£º
col1      col2
a(001)    a(001).1
a(002)    a(002).1
a(003)    a(003).1
...
b(001)    b(001).1
b(002)    b(002).1
b(003)    b(003).1
...
¸Ð¾õ°Ñ±í2¸Ä³ÉÕâÑù»¹±È½ÏºÃ¸Ä

SQL code:
SELECT T2.COL1,T2.COL1+RIGHT(T1.COL2,2)AS COL2 INTO #T
from TB1 T1,TB2 T2 WHERE T1.COL1=LEFT(T2.COL1,1)

DELET TB1
INSERT TB1 SELECT * from #T



SQL code:
SELECT T2.COL1,T2.COL1+RIGHT(T1.COL2,2)AS COL2 INTO #T
from TB1 T1,TB2 T2 WHERE T1.COL1=LEFT(T2.COL1,1)

DELETE TB1
INSERT TB1 SELECT * from #T




SQL code



Code highlighting produced by Actipr


Ïà¹ØÎÊ´ð£º

sql ʱ¼äÎÊÌâ

sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001

ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......

sqlÈ¡²éѯֵ

ÈçÌ⣺select name from table1
µÃµ½½á¹û£ºname
          СÍõ
          СÕÔ
          СÀî
      ......

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.¿¨ ......

¹ØÓÚSQL 2008

Ò»Ö±ÓÃ2000£¬Ïëѧ2008.
ÇëÎÊ
1. 2008±È2000ÓÐÄÄЩ¸ü·½±ãµÄÓ¦Óã¿
2. MSSQL 2008 Ö§³ÖÄÄЩϵͳ£¿ XP¿ÉÒÔ°²×°Âð£¿
3. ÔÚÄÄÓÐÏÂÔØ£¬×îºÃÊÇÃâϵÁкţ¬¼´D°æ¡£

лл£¡
ÎÒÒ²ÓÃ2000

1.Ì«¶àÁË ×Ô¼ºÈ¥ ......

SQL½»²æ²é詢

  data            a        b        c        d        e  tag
2009-11-01 11 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ