新增文章

文章标题 分类 C# 云星空 K3 BOS K3 功能 用友 Oracle python SQL MySql PHP HTML script windows Access 影视后期 财务 服务 生活 内容 declare @id int,@name varchar(20),@lass varchar(20) declare cursor_1 cursor for (select id ,name ,class from student) open cursor_1 fetch next from cursor_1 into @id,@name,@lass while @@FETCH_STATUS=0 begin insert into #temp(id,name,class) values( @id,@name,@lass ); insert into #temp(id,name,class) select id,name,class from student where id = @id; fetch next from cursor_1 into @id ,@name,@lass end close cursor_1 deallocate cursor_1 返回 保存