sqlserver游标

declare @index nvarchar(10);
set @index='100001'
declare mycur cursor
for select interactid from OnlineInteract
where interactcategoryid=1 order by createtime asc
declare @id int;
open mycur
fetch next from mycur into @id
while @@fetch_status=0
--更新创建时间，随机的时间
begin
update OnlineInteract set indexnumber=@index where interactid=@id
set @index=@index+1
fetch next from mycur into @id
end
---关闭游标
close mycur

deallocate mycur