游标定义

游标定义

 

declare @salaryitemid int
declare salaryitem_cursor cursor
for
select salaryitemid from payroll.salaryitem where companyid = @companyid order by salaryitemid 
open salaryitem_cursor
fetch next from salaryitem_cursor into @salaryitem
while (@@fetch_status<>-1)
begin

-----------

fetch next from salaryitem_cursor into @salaryitemid
end
close salaryitem_cursor

deallocate salaryitem_cursor 

 

借沉浮的