22,302
社区成员




---这样写
insert into lwmain2.dbo.LWnhdd(nh,dd,azwz,x,y,dwz,bm,sblb)
select nh,dd,azwz,x,y,dwz,bm,sblb from lwmain1.dbo.LWnhdd
where lwmain1.dbo.LWnhdd.nh not in(select nh from lwmain2.dbo.LWnhdd.nh)
INSERT INTO [lwmain2].dbo.LWnhdd
( nh ,
dd ,
azwz ,
x ,
y ,
dwz ,
bm ,
sblb
)
SELECT nh ,
dd ,
azwz ,
x ,
y ,
dwz ,
bm ,
sblb
FROM [lwmain1].dbo.LWnhdd
WHERE [lwmain1].dbo.LWnhdd.nh NOT IN (SELECT [lwmain2].dbo.LWnhdd.nh FROM [lwmain2].dbo.LWnhdd)
insert into lwmain2.dbo.LWnhdd(nh,dd,azwz,x,y,dwz,bm,sblb)
select lwmain1.dbo.LWnhdd.nh,lwmain1.dbo.LWnhdd.dd,lwmain1.dbo.LWnhdd.azwz,lwmain1.dbo.LWnhdd.x,lwmain1.dbo.LWnhdd.y,lwmain1.dbo.LWnhdd.dwz,lwmain1.dbo.LWnhdd.bm,lwmain1.dbo.LWnhdd.sblb from lwmain1.dbo.LWnhdd
where lwmain1.dbo.LWnhdd.nh<>lwmain2.dbo.LWnhdd.nh
INSERT INTO [lwmain2].dbo.LWnhdd
( nh ,
dd ,
azwz ,
x ,
y ,
dwz ,
bm ,
sblb
)
SELECT nh ,
dd ,
azwz ,
x ,
y ,
dwz ,
bm ,
sblb
FROM [lwmain1].dbo.LWnhdd
WHERE [lwmain1].dbo.LWnhdd.nh <> [lwmain2].dbo.LWnhdd.nh