How can I use select in a SQL Server while loop?

Anonymous User 2699 22 Oct 2013

How can I use select in a SQL Server while loop? Below have my demo code: -

 declare @loopVal integer

 set @loopVal =1

 while (@loopVal <10)

 begin

   select @loopVal as m;

   set @loopVal =@loopVal +1

 END

I want it to return all select results in one table but it will returns 10 separate table ... how can I achieve my task?

Please help me out…!!!!

1 Answers

Samuel Fernandes 22 Oct 2013

declare @loopVal integer

DECLARE @testTable TABLE(

   /*Write your data type here*/

)

 set @loopVal =1

 while (@loopVal <10)

 begin

   insert into @testTable select @loopVal;

   set @loopVal =@loopVal +1

 END 

select * from @testTable

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

How can I use select in a SQL Server while loop?

Can you answer this question?

1 Answers