While loop example - T-Sql Stored Procedure

While loop example - T-Sql Stored Procedure

In most of the queries we are using while loops for fetching, inserting,deleting records. In this example i am showing a while loop example in the stored procedure.

create procedure sp_WhileLoop
as
begin
declare @count int
set @count=1
  while(@count<=5)
  begin
     print @count
     set @count=@count+1
  end
end

Output:

1
2
3
4
5

SQL Server Interview Questions