DECLARE @TEST INT DECLARE a_cursor Cursor FOR SELECT siTestScore FROM INTERNALCANDIDATE OPEN a_cursor FETCH NEXT FROM a_cursor INTO @TEST WHILE @@FETCH_STATUS=0 BEGIN WHILE @TEST>80 BEGIN SET @TEST=100 END FETCH NEXT FROM a_cursor INTO @TEST END CLOSE a_cursor DEALLOCATE a_cursor
DECLARE a_cursor Cursor FOR
SELECT siTestScore FROM INTERNALCANDIDATE
OPEN a_cursor
FETCH NEXT FROM a_cursor INTO @TEST
WHILE @@FETCH_STATUS=0
BEGIN
WHILE @TEST>80
BEGIN
SET @TEST=100
END
FETCH NEXT FROM a_cursor INTO @TEST
END
CLOSE a_cursor
DEALLOCATE a_cursor
最简单的方法就是使用游标!