declare cursor_test8 cursor KEYSET for
select col001 from info
open cursor_test8
FETCH FIRST from cursor_test8
declare @k varchar(40)
while (@@fetch_status =0)
begin
fetch next from cursor_test8 into @k
insert into info2 values(@k)
end
close cursor_test8