cursor 的使用

declare @uid bigint
declare cursor_uid cursor for
    select id
    from [User]
    where validity = 1
open cursor_uid
    fetch next from cursor_uid  into @uid
   
    while @@fetch_status = 0
    begin
        select @uid
    fetch next from cursor_uid into @uid
    end       
close cursor_uid
deallocate cursor_uid

转载于:https://www.cnblogs.com/yubuaishui/archive/2011/07/04/2097623.html