摘要： create table tablea( tid int , mid int)gocreate table tableb( fid int, tid int)gobegin declare @coun int set @coun=1 while @coun<20 begin insert into tablea values(20,@coun) insert into tableb values(@coun,@coun) set @coun=@coun+1 endendgoupdate tablea set tablea.tid=tableb.fidfrom tablebwhere ta 阅读全文