±¾È˳õѧSQL£¬Çó¸ßÊÖ¸öÓï¾ä - MS-SQL Server / »ù´¡Àà

¼ÙÈçÓÐÁ½ÕűíA¡¢B
AÖÐÓÐÁ½ÁÐÊý¾Ý£¬ÁÐÃû·Ö±ðÊÇBH1¡¢201005£¨ÁÐ201005Ϊ¿Õ£©
BÖÐÓÐÁ½ÁÐÊý¾Ý£¬ÁÐÃû·Ö±ðÊÇBH2¡¢ggg£¨ÁÐgggÖÐÓÐÖµ£©
AÖÐBH1µÈÓÚBÖÐBH2ʱ£¬ÒªÊ¹AÖÐ201005È¡BÖÐgggµÄÖµ£¬ÈçºÎʵÏÖ£¿

---

SQL code:
update a set a.[201005]=b.ggg from b where a.bh1=b.bh2

---

update A set [201005]=ggg from B WHERE BH1=BH2

---

SQL code:
update
a
set
[201005]=n.ggg
from
a,b
where
a.bh1=b.bh2

---

select A.BH1,B.ggg from A,B where A.BH1=B.BH2

---

up!

---

ÒýÓÃ

ÒýÓà 1 Â¥ htl258 µÄ»Ø¸´:
SQL code
update a set a.[201005]=b.ggg from b where a.bh1=b.bh2


update
a
set
[201005]=b.ggg
from
a,b
where
a.bh1=b.bh2

²»ÄÜÓÃa.[201005]

Ϊʲô

---

SQL code:
--> Éú³É²âÊÔÊý¾Ý±í: [a]
IF OBJECT_ID('[a]') IS NOT NULL
DROP TABLE [a]
GO
CREATE TABLE [a] ([BH1] [nvarchar](10),[201005] [nvarchar](10))
INSERT INTO [a]
SELECT '001',NULL UNION ALL
SELECT '002',NULL

--> Éú³É²âÊÔÊý¾Ý±í: [b]
IF OBJECT_ID('[b]') IS NOT NULL
DROP TABLE [b]
GO
CREATE TABLE [b] ([BH