游标

DECLARE @循环值 nvarchar(50) DECLARE _游标 CURSOR FOR SELECT 循环字段 FROM TableName --查询需要循环字段 OPEN _游标 FETCH NEXT FROM _游标 INTO @循环值 WHILE @@FETCH_STATUS = 0 BEGIN END FETCH NEXT FROM _游标 INTO @循环值 CLOSE _游标 DEALLOCATE _游标