USE tempdb
GO
IF OBJECT_ID('t') IS NOT NULL
DROP TABLE t
GO
CREATE TABLE t(
stuId INT IDENTITY(1,1) PRIMARY KEY,
stuName nvarchar(10) NOT NULL,
score INT NOT NULL
)
GO
INSERT INTO t(stuName,score) VALUES('小明',10)
INSERT INTO t(stuName,score) VALUES('小红',20)
INSERT INTO t(stuName,score) VALUES('小月',50)
------------- 以上为测试表及测试数据 ---------------
SELECT * FROM t
/*
stuId stuName score
1 小明 10
2 小红 20
3 小月 50
*/
--注:cross apply 效果一样
UPDATE a
SET a.score=a.score+b.score
FROM t AS a CROSS JOIN t AS b
WHERE a.stuId=1 AND b.stuId=3
SELECT * FROM t
/*
stuId stuName score
1 小明 60
2 小红 20
3 小月 50
*/