declare @tid int
declare @fid int
declare @i int
declare @j int
set @j=(select count(*) from tbl1.dbo.dnt_topics)
set @i=1
while @i<@j
begin
set @tid = (select tid from ( select ROW_NUMBER() over (order by tid asc ) as Row, tid,fid from dnt_topics ) as sp where Row=@i)
set @fid=(select fid from ( select ROW_NUMBER() over (order by tid asc ) as Row, tid,,fid from dnt_topics ) as sp where Row=@i)
update
tbl2.dbo.dnt_topics
set
fid=@fid
where
tid=@tid
set @i=@i+1
end
declare @fid int
declare @i int
declare @j int
set @j=(select count(*) from tbl1.dbo.dnt_topics)
set @i=1
while @i<@j
begin
set @tid = (select tid from ( select ROW_NUMBER() over (order by tid asc ) as Row, tid,fid from dnt_topics ) as sp where Row=@i)
set @fid=(select fid from ( select ROW_NUMBER() over (order by tid asc ) as Row, tid,,fid from dnt_topics ) as sp where Row=@i)
update
tbl2.dbo.dnt_topics
set
fid=@fid
where
tid=@tid
set @i=@i+1
end
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步