Example of WHILE Loop in SQL Server

DECLARE @intFlag INT
SET @intFlag = 1
WHILE (@intFlag <=5)
BEGIN
PRINT @intFlag
SET @intFlag = @intFlag + 1
END
GO

Cursor Example SQL Server

DECLARE @id int
DECLARE mycursor CURSOR FOR
SELECT empid FROM tblemp

OPEN mycursor  
FETCH NEXT FROM mycursor INTO @id  

WHILE @@FETCH_STATUS = 0  
BEGIN  
       select * from tblsalary where empid=@id

       FETCH NEXT FROM mycursor INTO @id  
END  

CLOSE mycursor  
DEALLOCATE mycursor