游标能否用在临时表上?
xf2gl 2005-03-14 10:49:56 有一个全局临时表##table_temp,如下使用游标可以吗?
declare cursor_in cursor for
select class1,class2,class3,class4,class5 from ##xc_material_class_temp
fetch next from cursor_in into @class1,@class2,@class3,@class4,@class5
while @@fetch_status=0
begin
.
.
fetch next from cursor_in into @class1,@class2,@class3,@class4,@class5
end
close cursor_in
deallocate cursor_in