While Loop With Example In SQL Server

Published: 04 October 2022
on channel: TechVeda

487

Sometimes you have to iterate or loop through available data. SQL Server provide many looping techniques and i am explaining While loop with example here.

--While Loop in SQL Server
--select * from Employee

select ROW_NUMBER() over(order by EmpId) as Rn, * into #Emp from Employee

Declare @TotalCount int, @Counter int, @EmpId int, @EmpName varchar(100), @Salary int
select @TotalCount=COUNT(1) from #Emp
Set @Counter=1
-- Less than or greater than symbol is not allowed in description to -----removing that from example and only kept "="
While @Counter=@TotalCount
Begin
Select @EmpId=EmpId,@EmpName=EmpName,@Salary=Salary from #Emp where Rn=@Counter
Print Concat(@EmpId,' '+ @EmpName +' ' , @Salary)

Set @Counter+=1
End

Drop table #Emp

On this page of the site you can watch the video online While Loop With Example In SQL Server with a duration of hours minute second in good quality, which was uploaded by the user TechVeda 04 October 2022, share the link with friends and acquaintances, this video has already been watched 487 times on youtube and it was liked by 8 viewers. Enjoy your viewing!

262