假设有a b两张table
a：id，name
b:ID，name
declare @id int
declare @name char(20)
declare E1cur cursor for
select id,name from a
open E1cur
fetch E1cur into @id,@name
while @@fetch_status=0
begin
insert into b
select @id,@name
fetch E1cur into @id,@name
end
close E1cur
deallocate E1cur
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024