SQL Server遍历表(临时表)

-- 声明变量DECLARE@userID INT,@userName VARCHAR(50)SELECT ID INTO #temp FROM As_UserWHILE EXISTS(SELECT ID FROM #temp)BEGIN-- 取值SELECT top 1 @userID= ID FROM #temp;-- 操作print(@userID)-- 删除本次操作数据DELETE FROM #temp WHERE ID=@userID;END-- 是否删除临时表-- DROP TABLE #temp