T-SQL,在单个选择中更新多个变量

SET @Variable1 = expression1, @Variable2 = expression2, ...;

DECLARE @Var1 INT = 10;
DECLARE @Var2 INT = 20;

SET @Var1 = @Var1 + 5, @Var2 = @Var2 - 5;

SELECT @Var1 AS 'Var1', @Var2 AS 'Var2';

UPDATE table_name
SET column1 = expression1, column2 = expression2, ...
WHERE condition;

DECLARE @Table TABLE (ID INT, Var1 INT, Var2 INT);

INSERT INTO @Table (ID, Var1, Var2)
VALUES (1, 10, 20), (2, 30, 40);

UPDATE @Table
SET Var1 = Var1 + 5, Var2 = Var2 - 5
WHERE ID = 1;

SELECT * FROM @Table;