SQL with numbers

Question

I am trying to build a loop with SQL Server.

When I execute SELECT 1 UNION SELECT 2 UNION SELECT 3; SQL Server creates a table with 1 column and 4 rows.

Can anyone think of a way to achive the same however without using UNION?

Answer 1

You can use the values() table constructor:

select *
from (values (1), (2), (3), (4)) v(n);