参考链接：http://www.cnblogs.com/youngberry/archive/2009/07/17/1525647.html
SQL Server 游标使用
标签：code desc archive time sort cursor com index user
SQL Server 游标使用
@index int;
declare @userId uniqueidentifier;
set @index=1;
declare user_cur cursor for select UserId from T_User order by CreateTime desc
open user_cur
fetch next from user_cur into @userId
while (@@FETCH_STATUS=0)
begin
update T_User set Sort=@index where UserId=@userId;
set @index=@index+1;
fetch next from user_cur into @userId
end
close user_cur;
deallocate user_cur;