游标使用方法

--定义游标
declare @username1 varchar(20),@userid1 varchar(100)
declare cursor_1 cursor for --
select  top 10  name ,gonghao from usergonghao where userstatus<>'离职员工' order  by gonghao asc
 open cursor_1
 fetch next from cursor_1 into @username1,@userid1
 while @@FETCH_STATUS=0
    begin 
    print '用户id:'+@userid1    +'          '+'用户名：'+@username1

--提取下一条数据
    fetch next from  cursor_1 into @username1,@userid1
    end

--关闭游标
    close cursor_1

--释放游标
    deallocate cursor_1