Create numbers table in T-SQL

create table dbo.numbers (
 number int primary key
);
GO

declare @i as int = 1;
declare @end as int = 1000000;

begin transaction
while(@i < @end)
begin
    insert into numbers values(@i)
    set @i += 1
end
commit transaction

select COUNT(*) from numbers;