例:declare cursor_insert cursor for select c# from cs
declare
@i int
open cursor_insert
fetch cursor_insert into @i
while @@fetch_status=0
begin
print @i
fetch cursor_insert into @i
end
close cursor_insert
deallocate cursor_insert
declare
@i int
open cursor_insert
fetch cursor_insert into @i
while @@fetch_status=0
begin
print @i
fetch cursor_insert into @i
end
close cursor_insert
deallocate cursor_insert
declare @project_id int
declare @user_id int
declare @property_id int
declare @number varchar(40)
declare @content varchar(1000)
declare @explain varchar(1000)
declare @occur_date datetime
declare @adjust_date datetime
declare @submit_date datetime
declare @finish int
declare @img int
declare my_first_cursor cursor
local
fast_forward
for
select * from prj_qualityopen my_first_cursorfetch next from my_first_cursor into
@id, @project_id, @user_id, @property_id, @number, @content, @explain, @occur_date, @adjust_date, @submit_date, @finish, @imgwhile (@@FETCH_STATUS = 0)
begin
insert into prj_bk_quality (project_id, [user_id], property_id, number, content, explain, occur_date, adjust_date, submit_date, finish, img, op_id, operate)
values (@project_id, @user_id, @property_id, @number, @content, @explain, @occur_date, @adjust_date, @submit_date, @finish, @img, @id, '添加') fetch next from my_first_cursor into
@id, @project_id, @user_id, @property_id, @number, @content, @explain, @occur_date, @adjust_date, @submit_date, @finish, @img
end
close my_first_cursor我要将一个表中的内容复制到另一个表中,这两个表的结构不完成相同。在第二个fetch next出现错误,提示我游标没有打开,如果不在上面使用就好用,我想问问这是什么原因。有没有其它的替代方法,在不考虑效率问题前提下。因为只执行一次,修改过去的程序用的。谢谢!
godeclare dali_cursor scroll cursor for------------定义游标
select * from jobs where max_lvl>100 ----------游标体查找语句
open dali_cursor-----------------打开游标 -------fetch next from dali_cursor------------提取游标-----next---last
close dali_cursor------------------关闭游标
deallocate dali_cursor------------释放游标
select project_id,user_id,property_id,number,content,explain,occur_date,adjust_date,submit_date,finish,img,id,'添加' from prj_quality这一句可以搞定你的需求,不需要用游标!
select project_id,[user_id],property_id,number,content,explain,occur_date,adjust_date,submit_date,finish,img,id,'添加' from prj_quality