DECLARE @SampleCrsr CURSOR declare @Str varchar(500) set @samplecrsr=cursor FOR SELECT distinct 地域 FROM 地域表 WHERE ......... OPEN @SampleCrsr FETCH NEXT FROM @SampleCrsr into @Str
while @@fetch_status=0 BEGIN --print @str Update TABLE1 SET 字段='..' where (条件 @STR) FETCH NEXT FROM @SampleCrsr into @str END CLOSE @SampleCrsr DEALLOCATE @SampleCrsr
set col = ...
where ....
DECLARE @SampleCrsr CURSOR
declare @Str varchar(500) set @samplecrsr=cursor FOR
SELECT distinct 地域
FROM 地域表 WHERE ......... OPEN @SampleCrsr
FETCH NEXT FROM @SampleCrsr into @Str
while @@fetch_status=0
BEGIN
--print @str
Update TABLE1 SET 字段='..' where (条件 @STR)
FETCH NEXT FROM @SampleCrsr into @str
END CLOSE @SampleCrsr DEALLOCATE @SampleCrsr
用游标