用遊标，和WHILE可以周遊您的查詢中的每一條記錄并将要求的字段傳給變量進行相應的處理
==================
代碼
DECLARE @A1 VARCHAR(10),@A2 VARCHAR(10),@A3 INT
DECLARE YOUCURNAME CURSOR FOR SELECT A1,A2,A3 FROM YOUTABLENAME
OPEN YOUCURNAME
fetch next from youcurname into @a1,@a2,@a3
while @@fetch_status<>-1
begin
update ... set ...=@a1,...=a2 ...-a3 where ...
......您要執行的操作寫在這裡
end
close youcurname
deallocate youcurname