一个Sql Server 的例子
declare mycursor cursor for --声明游标变select GROUP_NAME from USER_GROUP
open mycursor --打开游标
declare @Fieldvarchar(100)--声明临时存放GROUP_NAME的变量
declare @JG_IDvarchar(100)--声明临时存放JG_ID的变量
declare @JG_XHvarchar(100)--声明临时存放JG_XH的变量
fetch next from mycursor into @Field
begin
while(@@fetch_status=0)
begin
set @JG_ID = (select max(JG_ID)+1as JG_ID from jg)
set @JG_XH = (select max(JG_XH)+1as 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
页:
[1]