34,593
社区成员
发帖
与我相关
我的任务
分享
--> 数据库版本:
--> Microsoft SQL Server 2008 (RTM) - 10.0.1600.22
--> 测试数据:A
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'A')
AND type in (N'U'))
DROP TABLE A
GO
---->建表
create table A([AID] varchar(1),[A1] int,[A2] int,[A3] int)
insert A
select 'a',1,2,3 union all
select 'b',2,3,4 union all
select 'c',3,4,5
GO
--> 数据库版本:
--> Microsoft SQL Server 2008 (RTM) - 10.0.1600.22
--> 测试数据:B
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'B')
AND type in (N'U'))
DROP TABLE B
GO
---->建表
create table B([BID] varchar(1),[B1] int,[B2] int,[B3] int)
insert B
select 'a','1111','2222','3333' union all
select 'b','1111','2222','3333' union all
select 'd','1111','2222','3333'
GO
--> 查询结果
SELECT * FROM A
--> 删除表格
--DROP TABLE A
--> 查询结果
SELECT * FROM B
--> 删除表格
--DROP TABLE B
UPDATE A
SET A1 = B1, A2 = B2, A3 = B3
FROM A , B
WHERE A.AID = B.BID
SELECT * FROM A
UPDATE A
SET A1 = B1, A2 = B2, A3 = B3
FROM A INNER JOIN B ON A.AID = B.BID
SELECT * FROM A
CREATE TABLE #A
(
ID INT IDENTITY,
A1 VARCHAR(10),
A2 VARCHAR(10),
A3 VARCHAR(10)
)
CREATE TABLE #B
(
ID INT IDENTITY,
B1 VARCHAR(10),
B2 VARCHAR(10),
B3 VARCHAR(10)
)
INSERT INTO #A SELECT 'AA','BB','CC'
INSERT INTO #A SELECT 'DD','EE','FF'
INSERT INTO #A SELECT 'HH','XX','XX'
INSERT INTO #B SELECT '11','22','33'
INSERT INTO #B SELECT '44','55','66'
INSERT INTO #B SELECT '77','88','99'
只用A.ID = B.ID的记录才会被B表对应值更新!