Cursor Example

declare cursor_fetch cursor for select * from spt_values

open cursor_fetch

fetch cursor_fetch

close cursor_fetch

deallocate cursor_fetch