DECLARE @i int set @i=0 --更新题序编号 UPDATE UserAnswer SET @i=@i+1,TestOrder=@i WHERE UserScoreID='143' //根据ID 累加更新
DECLARE @i int set @i=0 --更新题序编号 UPDATE UserAnswer SET @i=@i+1,TestOrder=@i WHERE UserScoreID='143' //根据ID 累加更新
转载于:https://www.cnblogs.com/dragon-L/p/4159369.html