sqlserver游标的使用

CREATE PROCEDURE CityTest
as

declare @name varchar(200),@rome varchar(300)
declare mycur cursor scroll  for (select top 5 name,rome from area)
open mycur
fetch next from mycur into @name,@rome
while @@fetch_status=0
begin
fetch last from mycur into @name,@rome
insert into test values (@name,@rome)
end
close mycur
deallocate mycur
GO