一次排序序号的补充

由于疏忽，数据库的排序字段，成了0，导致，排序出现错误

下面这个，单独执行，给再加上了排序

declare @testPagerId int
set @testPagerId=12

IF OBJECT_ID('dbo.#GroupQuestion','U') IS NOT NULL DROP TABLE dbo.#GroupQuestion;

SELECT *
INTO dbo.#GroupQuestion
FROM  GroupQuestion where testPagerId=@testPagerId
order by id

-- 声明变量
DECLARE
    @id INT,
    @rank int
set @rank=0
    
WHILE EXISTS(SELECT id FROM dbo.#GroupQuestion)
BEGIN
    -- 也可以使用top 1
    set @rank=@rank+1
    SELECT top 1 @id=id FROM dbo.#GroupQuestion;
    UPDATE GroupQuestion SET sort=@rank WHERE id=@id;    
    DELETE FROM dbo.#GroupQuestion WHERE id=@id;
END
select * from dbo.#GroupQuestion
DROP TABLE dbo.#GroupQuestion;