ÇóÖú£º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
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001
ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
sql server browserºÍsql server sql server expressÊǸÉÂðµÄ
ÎÒÖ»ÊÇÓÃSQL2005×öÍøÕ¾Êý¾Ý¿â£¬ÇëÎÊ¿ÉÒÔ½ûÓÃÂð£¿
ÎÒÏë½ÚÔ¼·þÎñÆ÷×ÊÔ´
»¹ÓÐÒ»¸ösql server fill text search
Õâ¸öÓ¦¸ÃÊÇÈ«ÎÄËÑË÷°É£¬¿ÉÒÔÒ²¿ÉÒ ......
±íA
¿¨ºÅ ʱ¼ä
1 null
2 null
3 & ......
ÎÊÌâÃèÊö£º
ÎÒÓõÄÊÇsql 2000
ÆóÒµ¹ÜÀíÆ÷->Õ¹¿ª·þÎñÆ÷->¹ÜÀí->SQL Agent->ÊôÐÔ
ÔÚ´¦À´µÄSQL Server´úÀíÊôÐÔ¶Ô»°¿òÖÐ Óʼþ»á»°Ñ¡Ïî¿òÏÂÃæµÄ ÓʼþÅäÖÃÎļþ ²»ÄÜÓà ³ÊÏÖ»ÒÉ«
ÎÒͬѧµÄÈ´ÄÜÓᣠ......