--主表不同数据
select * from [bd]..TabA where TabAID not in (select TabAID from [fwq]..TabA);
--子表不同数据
select b.* from [bd]..TabB b join [bd]..TabA a on a.TabAID=b.TabAID where a.TabAID not in (select TabAID from [fwq]..TabA));
--从本地同步到服务器 本地库名:bd 服务器库名:fwq 主表:TabA 子表:TabB
declare @i int=0; --循环初始值
declare @j int=0; --循环总记录数
declare @TabAID int=0; --主表主键
declare @newTabAID int=0; --插入后生成的主键
select @j = count(1) from [bd]..TabA where TabAID not in (select TabAID from [fwq]..TabA);
--获取最大的一条主表记录
select top 1 @TabAID = TabAID from [bd]..TabA where TabAID not in (select TabAID from [fwq]..TabA) order by TabAID desc;
while @i<@j
begin
--插入主表不同数据
insert into [fwq]..TabA (TabAName,TabAOrder)
select TabAName,TabAOrder from [bd]..TabA where TabAID = @TabAID;
--返回主表主键
select @newTabAID = @@IDENTITY;
--输出新旧主键
select @TabAID 原主键,@newTabAID 新主键
--根据主表主键,插入子表数据
insert into [fwq]..TabB (TabAID,TabBName,TabBOrder)
select @newTabAID,TabBName,TabBOrder from [bd]..TabB where TabAID = @TabAID;
--获取下一条主表记录(<@TabAID)
select top 1 @TabAID = TabAID from [bd]..TabA where TabAID not in (select TabAID from [fwq]..TabA) and TabAID < @TabAID order by TabAID desc
set @i=@i+1
end;