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