表b 字段id为整数
怎么将1到100 插入表b中
create table #(id int)
declare @i int
set @i=1
while @i<=100
begin
insert into # select @i
set @i=@i+1
end
select * from #
表b 字段id为整数
怎么将1到100 插入表b中
create table #(id int)
declare @i int
set @i=1
while @i<=100
begin
insert into # select @i
set @i=@i+1
end
select * from #