DECLARE @IdPriceUSD CURSOR SET @IdPriceUSD = CURSOR LOCAL SCROLL FOR SELECT G_ID FROM TBL_GOODS OPEN @IdPriceUSD FETCH NEXT FROM @IdPriceUSD WHILE @@FETCH_STATUS = 0 BEGIN UPDATE TBL_GOODS SET price3 = price * 8.17 WHERE G_ID = @IdPriceUSD FETCH NEXT FROM @IdPriceUSD END CLOSE @IdPriceUSD DEALLOCATE @IdPriceUSD
