I am doing a table fill in SQL. Created a temporary table, for example
create table #sometable2 (id int,n int,m int,v int, b int) SET @i=1 WHILE @i<=100 BEGIN
there is a big work code to fill out
insert in temporary table
insert into #sometable2 values (@id,@n,@m,@v,@b) SET @i=@i+1 END insert into MyTable values (@id,@n,@m,@v,@b) select * from #sometable2 order by sid DROP TABLE #sometable2
sorted, and now I need to put all this data into the existing main table. But the problem is that I do not write 100 lines to the main table, for example (that is, how many of them), but only 1.