While loop, If Condition, and break statement example in SQL Server T-Sql

alter procedure sp_WhileLoop
as
begin
declare @count int
set @count=1
  while(@count<=5)
  begin
     print @count
      if(@count=3)
     begin
        break
     end
     set @count=@count+1
  end
end

output:

1
2
3