Mega Code Archive
Using SELECT to Assign Variables
<![CDATA[
1> -- Using SELECT to Assign Variables
2>
3> DECLARE @MyNumber1 Int, @MyNumber2 Int, @MyResult1 Int, @MyResult2 Int
4>
5> SELECT @MyNumber1 = 144, @MyNumber2 = 121
6> -- Assign the function result to the variable:
7>
8> SELECT @MyResult1 = SQRT(@MyNumber1), @MyResult2 = SQRT(@MyNumber2)
9> -- Return the variable value
10> SELECT @MyResult1, @MyResult2
11> GO
----------- -----------
12 11
(1 rows affected)
1>
2>
]]>