FROM句を使ったUPDATE statementのサンプル [Database]
USE AdventureWorks;
GO
CREATE TABLE Table1
(ColA int NOT NULL, ColB decimal(10,3) NOT NULL);
GO
CREATE TABLE Table2
(ColA int PRIMARY KEY NOT NULL, ColB decimal(10,3) NOT NULL);
GO
INSERT INTO Table1 VALUES(1, 10.0);
INSERT INTO Table1 VALUES(1, 20.0);
INSERT INTO Table2 VALUES(1, 5.0);
GO
UPDATE Table2 SET
ColB = T2.ColB + T1.ColB
FROM Table2 T2
INNER JOIN Table1 T1
ON T2.ColA = T1.ColA
GO
Table2の結果
ColA ColB
2 25.000
http://technet.microsoft.com/ja-jp/library/ms177523(SQL.90).aspx
GO
CREATE TABLE Table1
(ColA int NOT NULL, ColB decimal(10,3) NOT NULL);
GO
CREATE TABLE Table2
(ColA int PRIMARY KEY NOT NULL, ColB decimal(10,3) NOT NULL);
GO
INSERT INTO Table1 VALUES(1, 10.0);
INSERT INTO Table1 VALUES(1, 20.0);
INSERT INTO Table2 VALUES(1, 5.0);
GO
UPDATE Table2 SET
ColB = T2.ColB + T1.ColB
FROM Table2 T2
INNER JOIN Table1 T1
ON T2.ColA = T1.ColA
GO
Table2の結果
ColA ColB
2 25.000
http://technet.microsoft.com/ja-jp/library/ms177523(SQL.90).aspx
コメント 0