游标的使用

遍历某个表时要用到游标
declare HistoryCur cursor for
select _order,dataitemid from #idlist;
declare @tablename varchar(50);
declare @itemid int;
open HistoryCur;
fetch next from HistoryCur into @tablename,@itemid;
while(@@fetch_status <> -1) --等于 -1表示没有遍历完成
begin
 --对@tablename,@itemid进行操作
 fetch next from HistoryCur into @tablename,@itemid;
end