在存储过程中自定义表，插入数据并查询

declare @totalNum int
Set @totalNum=5

declare @indextable1 table(id int identity(1,1),totalNum int)
declare @i int
SEt @i=0
while @i<@totalNum
begin
insert into @indextable1(totalNum) values(@totalNum)
Set @i=@i+1
end

select * from @indextable1

得到如下结果：