--用游标
declare @uname varchar(200)
declare cur1 cursor for select uname from table1 where uid=1
open cur1
fetch next from cur1 into @uname
while @@fetch_status=0
begin
--写入你要处理的语句
......
fetch next from cur1 into @uname
end
close cur1
deallocate cur1
declare @uname varchar(200)
declare cur1 cursor for select uname from table1 where uid=1
open cur1
fetch next from cur1 into @uname
while @@fetch_status=0
begin
--写入你要处理的语句
......
fetch next from cur1 into @uname
end
close cur1
deallocate cur1
select distinct fid from a
insert into tableb (fieldlist) select fieldlist from tablea where 条件
比如b字段的值为1,我insert into 到b的时候要转成a
我要得到值在转成我想要的值,再插到表b中
前的列和后面的列能保持一致就行了