mssql sql中类似for循环

declare @i int
set @i=1
while   @i<=28   
begin   
update question_result set newMemberId=5022+@i where resultId=@i
set @i=@i+1
end