這只是筆記本

CURSOR好用，撈出資料後可以一筆一筆去處理要做的事，不過小心喔～CURSOR很吃資源…

DECLARE @Data varchar(50)

DECLARE TableS CURSOR FORWARD_ONLY FOR

SELECT name FROM ATable WHERE A=’1′ ORDER BY name –取得資料

OPEN TableS

FETCH NEXT FROM TableS

INTO @Data

WHILE @@FETCH_STATUS = 0

BEGIN

–要處理的東西

INSERT INTO AAA (G) VALUES (@Data);

FETCH NEXT FROM TableS INTO @Data

END

CLOSE TableS

DEALLOCATE TableS