sql 语句的错误！

Question

　　　　　　  DECLARE @length int          --长度
            DECLARE @next int            --标量
            DECLARE @did int             --地区id
            DECLARE @sId1 int
            
            SET @stId=@@IDENTITY
            SET @next=0  
            SELECT @length=COUNT(*) FROM Subject
            WHILE(@next<@length)
            BEGIN
                
                SELECT TOP 1 @did=ccId FROM CityCountry 
                WHERE ccId NOT IN (SELECT TOP @next ccId FROM CityCountry)
                INSERT INTO IP_District_Sub_Relation(dId,sId,usrCustomID,usrState,usrRebate)
                VALUES(@dId,@sId1,0,0,0)
 
                SET @next=@next+1
            END

消息 102，级别 15，状态 1，过程 MS_InsertIP_Subject，第 71 行'@next' 附近有语法错误。

老提示错误，是怎么回事呢？

Answer 1

WHERE ccId NOT IN (SELECT TOP (@next) ccId FROM CityCountry)