有朋友问到,两个表如何链接更新,这里举例说明:
CREATE TABLE data1(
name NVARCHAR(8) NOT NULL,
sex CHAR(1) NOT NULL,
age INT default 0)
GO
CREATE TABLE data2(
name NVARCHAR(8) NOT NULL,
age INT NOT NULL CHECK(age>0))
GO
INSERT INTO data1(name,sex) VALUES
('王五','1'),
('张三','1'),
('李四','1')
GO
INSERT INTO data2 VALUES
('王五',23),
('张三',24),
('李四',28)
GO
/*更新data1的年龄为data2的相应年龄*/
UPDATE data1 SET age=(SELECT age FROM data2 WHERE name=data1.name)