sql 游标

declare @Storage int, @EdsProd intdeclare My_cursor cursor scroll for
select distinct Storage,EdsProd from InmInventory 
open My_cursor 
fetch next from My_cursor into @Storage,@EdsProd
while(@@fetch_status=0)
    begin
        select  @Storage as '仓库',@EdsProd as '产品'
        fetch next from My_cursor into @Storage,@EdsProd
    end
close My_cursor--关闭游标
deallocate My_cursor --释放游标