一个Sql Server 的例子

declare mycursor cursor for --声明游标变
select GROUP_NAME from USER_GROUP
open mycursor --打开游标
declare @Field varchar(100) --声明临时存放GROUP_NAME的变量
declare @JG_ID varchar(100) --声明临时存放JG_ID的变量
declare @JG_XH varchar(100) --声明临时存放JG_XH的变量
fetch next from mycursor into @Field
begin
while(@@fetch_status=0)
begin
set @JG_ID = (select max(JG_ID)+1 as JG_ID from jg)
set @JG_XH = (select max(JG_XH)+1 as JG_XH from jg)
insert into jg(RE, JG_ID, JG_NAME, JG_XH, BM_ID, BM_NAME, BM_XH, QZH_ID)
values ('', @JG_ID, @Field, @JG_XH, 0, '', 0, '1')
fetch next from mycursor into @Field
end
end
close mycursor
deallocate mycursor