forum

Home / DeveloperSection / Forums / How can I use select in a SQL Server while loop?

Ask Question

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

Anonymous User231722-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…!!!!


mssql servermssql server 
Updated on 22-Oct-2013
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Samuel Fernandes

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

Liked By