declare @a1 char(2) declare @b1 char(2) declare @c1 char(2) declare @d1 char(2) declare @e1 char(2) declare @f1 char(2) create table #tmp (id char(3),no1 char(2),no2 char(2)) declare cur1 cursor for select * from [table] open cur1 fetch next from cur1 into @a1,@b1,@c1,@d1,@e1,@f1 while @@fetch_status=0 begin insert into #tmp values('001',@a1,@b1) insert into #tmp values('002',@c1,@d1) insert into #tmp values('003',@e1,@f1) fetch next from cur1 into @a1,@b1,@c1,@d1,@e1,@f1 end select * from #tmp close cur1 deallocate cur1 drop table #tmp
create view v_MyView as select a as OrderCol,'001' as w,a,b from table union select a as OrderCol,'002' as w,c,d from table union select a as OrderCol,'003' as w,e,f from table goselect w,a,b from v_MyView order by OrderCol
游标怎么实现???请教。。
declare @b1 char(2)
declare @c1 char(2)
declare @d1 char(2)
declare @e1 char(2)
declare @f1 char(2)
create table #tmp (id char(3),no1 char(2),no2 char(2))
declare cur1 cursor for
select * from [table]
open cur1
fetch next from cur1 into @a1,@b1,@c1,@d1,@e1,@f1
while @@fetch_status=0
begin
insert into #tmp values('001',@a1,@b1)
insert into #tmp values('002',@c1,@d1)
insert into #tmp values('003',@e1,@f1)
fetch next from cur1 into @a1,@b1,@c1,@d1,@e1,@f1
end
select * from #tmp
close cur1
deallocate cur1
drop table #tmp
as
select a as OrderCol,'001' as w,a,b from table
union
select a as OrderCol,'002' as w,c,d from table
union
select a as OrderCol,'003' as w,e,f from table
goselect w,a,b from v_MyView order by OrderCol