updatedemo3.sql

来自「100多个SQL小程序,包含游标,基本增删改查,希望多你有用」· SQL 代码 · 共 33 行

/* 文件名称: UpdateDemo3.sql */
USE 北风贸易
GO

SET NOCOUNT ON
GO

CREATE TABLE MyTable1
(
id1 int PRIMARY KEY, number1 int
)
CREATE TABLE MyTable2
(
id2 int PRIMARY KEY, number2 int,number3 int
)

GO

INSERT INTO MyTable1 VALUES (1, 10)

INSERT INTO MyTable2 VALUES (1, 20, 30)
INSERT INTO MyTable2 VALUES (2, 40, 60)
  

UPDATE MyTable1 SET number1 = MyTable2.number2 + MyTable2.number3 
  FROM MyTable2
  WHERE MyTable2.id2 = 1

SELECT number1 FROM MyTable1

DROP TABLE MyTable1
DROP TABLE MyTable2