DECLARE @id BIGINT DECLARE tablecursor CURSOR FORWARD_ONLY FOR SELECT id FROM SCHEMA.table OPEN tablecursor FETCH NEXT FROM tablecursor INTO @id WHILE (1 = 1) BEGIN IF @@FETCH_STATUS <> 0 BREAK; PRINT @id --DO SOMETHING USEFUL HERE ! FETCH NEXT FROM tablecursor INTO @id END CLOSE tablecursor DEALLOCATE tablecursor
No comments:
Post a Comment