declare @col1 varchar(30)
declare @col2 varchar(30)
declare @da int
declare @str varchar(100)
declare @sex varchar(10)
declare @str1 varchar(100)
declare @str2 varchar(100)
create table #salary(
id int,
name varchar(50),
sex varchar(10),
)
declare @id int
set @id=0
set @da=1
set @sex='男'
exec('declare mycursor cursor for select id,name from test where sex='+''''+@sex+'''')
open mycursor
fetch next from mycursor into @id,@col1
while (@@fetch_status=0)
begin
--print @col1
--处理完一条后取下一条
insert #salary(id,name) values(@id,@col1);
set @sex=(select sex from test where id=@id);
update #salary set sex=@sex where id=@id
fetch next from mycursor into @id,@col1
end
close mycursor
deallocate mycursor
select * from #salary
drop table #salary
表的脚本及简单数据
[id] [int] NOT NULL ,
[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sex] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL
)
insert into test values('1','张三','男')
insert into test values('2','李四','男')