问尝试通过声明数据在T-SQL中进行排序时出错

EN

CREATE TABLE #NumbersArray
(
    ArrayIndex INT PRIMARY KEY,
    Value INT
)
GO

INSERT INTO #NumbersArray(ArrayIndex, Value)
    SELECT 0, 5
    UNION ALL
    SELECT 1, 1 
    UNION ALL
    SELECT 2, 3 
    UNION ALL
    SELECT 3, 4
    UNION ALL
    SELECT 4, 2

SELECT * FROM #NumbersArray
GO    

DECLARE @CurrentIndex INT,
        @MaxIndex INT,
        @swapoccured BIT

SET @swapoccured = 1
SET @MaxIndex = (SELECT COUNT(*) - 1 FROM #NumbersArray)

WHILE (@swapoccured = 1)
BEGIN
    SET @swapoccured = 0
    SET @CurrentIndex = 0

    WHILE (@CurrentIndex < @MaxIndex)
        DECLARE @value1 INT
        DECLARE @value2 INT
    BEGIN  -- Mistake was here. I put the begin in wrong place
        SET @value1 = (SELECT Value FROM #NumbersArray WHERE ArrayIndex = @CurrentIndex)
        SET @value2 = (SELECT Value FROM #NumbersArray WHERE ArrayIndex = @CurrentIndex + 1)

        IF (@value1 > @value2)
        BEGIN
            UPDATE #NumbersArray 
            SET Value = @value2 
            WHERE ArrayIndex = @CurrentIndex

            UPDATE #NumbersArray 
            SET Value = @value1 
            WHERE ArrayIndex = @CurrentIndex + 1

            SET @swapoccured = 1
         END

         SET @CurrentIndex = @CurrentIndex + 1
    END
END

SELECT * FROM #NumbersArray