ÇóÒ»¾äSQL - MS-SQL Server / »ù´¡Àà

table_a
id,c1,cont
1,a,NULL
1,b,NULL
2,a,NULL
2,b,NULL
3,c,NULL
3,d,NULL
--------------
table_b
id,cont
1,'ÕÅÈý'
1,'ÀîËÄ'
1,'ÕÅÈý'
2,'ÍõÎå'
2,'ÁõÈý'
3,'ÍõÎå'


Èç¹ûtable_a.id=table_b.id¾ÍÔÚtable_bÔÚËæ±ãÈ¡Ò»¸öcont¸üе½table_a±íÖÐcont£¬×îÖÕtable_a idÏàͬһ×écontÄÚÈÝÏàͬ

---

SQL code:
update ta set cont=(select top 1 cont from tb where id=ta.id)

---

SQL code:
update ta
set cont=(select top 1 cont from tb where id=ta.id order by cont)

ÐèÒªÒ»¸öÅÅÐò À´È·¶¨Ò»¸öÖµ

---

ÒýÓÃ

table_a
id,c1,cont
1,a,NULL
1,b,NULL
2,a,NULL
2,b,NULL
3,c,NULL
3,d,NULL
--------------
table_b
id,cont
1,'ÕÅÈý'
1,'ÀîËÄ'
1,'ÕÅÈý'
2,'ÍõÎå'
2,'ÁõÈý'
3,'ÍõÎå'


Èç¹ûtable_a.id=table_b.id¾ÍÔÚtable_bÔÚ¡­¡­

SQL code:

update table_a set cont=(select top 1 cont from table_b where table_b.id=table_a.id order by cont)

---

ÒýÓÃ

SQL code
update ta
set con