MS SQL等同于查询中的MySQL用户定义变量 [英] MS SQL equivalent to MySQL user defined variables in queries

问题描述

在MySQL中，如果要报告一个公式然后在另一个公式中使用该结果，则可以执行以下操作:

In MySQL, if you want to report a formula and then use that result in another formula, you can do something akin to:

SELECT @var1 := column1+column2 AS var1
, POWER(@var1,2) AS var2squared
FROM database.table;

MS SQL Server中是否有等效项?

Is there an equivalent in MS SQL Server?

推荐答案

您还可以使用CROSS APPLY:

You can also use CROSS APPLY:

SELECT v.Var1, POWER(v.Var1, 2) AS Var2Squared
    FROM [Table] t
    CROSS APPLY (SELECT t.Column1 + t.Column2 AS Var1) v
;

这篇关于MS SQL等同于查询中的MySQL用户定义变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！