8 January 2014

While loop and break statement example in SQL Server

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

output
1
2
3

No comments:

Post a Comment