SQL Output Multiple Local Variables into one Column

Question

Is it possible, using SQL, to output multiple separately defined local variables into one column as separate rows? Eg.

DECLARE var1 INT = 4
DECLARE var2 INT = 5
DECLARE var3 INT = 6

And then select the variables in some manner like

SELECT (var1, var2, var3) AS UserIDs,
       ('u1', 'u2', 'u3') AS Names

Which would produce the following table:

UserIDs | Names
   4    |  u1
   5    |  u2
   6    |  u3

Answer 1

Use Table valued constructor

SELECT *
FROM   (VALUES (@var1,'u1'),
               (@var2,'u2'),
               (@var3,'u3')) tc (UserIDs, Names)