部分代码 Insert tmp_main(a,b,c)select a,b,c from TabMenu Where bh='1001' --tmp_main的ID是自动增长的 set @tmpCur=cursor for select ID from tmp_main fetch next @tmpCur Into @ID while (@@fetch_status=0) begin Insert tmpB(num,name)select @ID,name From TabXM Where bh='1001' fetch next @tmpCur Into @ID end close @tmpCur那些select语句都能查到记录
Insert tmp_main(a,b,c)select a,b,c from TabMenu Where bh='1001'
--tmp_main的ID是自动增长的
set @tmpCur=cursor for
select ID from tmp_main
fetch next @tmpCur Into @ID
while (@@fetch_status=0)
begin
Insert tmpB(num,name)select @ID,name From TabXM Where bh='1001'
fetch next @tmpCur Into @ID
end
close @tmpCur那些select语句都能查到记录