Mega Code Archive

 

Categories / MSSQL Tutorial / Transact SQL

 

Multiple variables can be assigned values in a single operation

6> 7> DECLARE @MyNumber1 Int, @MyNumber2 Int, @MyResult1 Int, @MyResult2 Int 8> SELECT @MyNumber1 = 144, @MyNumber2 = 121 9> -- Assign the function result to the variable: 10> SELECT @MyResult1 = SQRT(@MyNumber1), @MyResult2 = SQRT(@MyNumber2) 11> -- Return the variable value 12> SELECT @MyResult1, @MyResult2 13> GO ----------- -----------          12          11 (1 rows affected)