游标使用

declare cur1 cursor static for
select djid,grdm,dwdm,djrq,djbz from m_rcdj with(nolock) where isnull(cs,0)=0 order by grdm,dwdm,djrq

open cur1
fetch next from cur1 into @djid,@grdm,@dwdm,@djrq,@djbz ;

while @@fetch_status=0
begin

fetch next from cur1 into @djid,@grdm,@dwdm,@djrq,@djbz ;
end
close cur1
deallocate cur1