Listing 1: Altering Multiple Variables in an UPDATE Statement UPDATE MyTable SET Optimized = True, @iOne = 1, @iTwo = 2, @iThree = 3, @iFour = 4, @iLoop = @iLoop + 1;