ÇóÖú£º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 table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001
ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
ÈçÌ⣺select name from table1
µÃµ½½á¹û£ºname
СÍõ
СÕÔ
СÀî
......
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.¿¨ ......
Ò»Ö±ÓÃ2000£¬Ïëѧ2008.
ÇëÎÊ
1. 2008±È2000ÓÐÄÄЩ¸ü·½±ãµÄÓ¦Óã¿
2. MSSQL 2008 Ö§³ÖÄÄЩϵͳ£¿ XP¿ÉÒÔ°²×°Âð£¿
3. ÔÚÄÄÓÐÏÂÔØ£¬×îºÃÊÇÃâϵÁкţ¬¼´D°æ¡£
лл£¡
ÎÒÒ²ÓÃ2000
1.Ì«¶àÁË ×Ô¼ºÈ¥ ......
data a b c d e tag
2009-11-01 11 ......