试试: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
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 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 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)
( 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
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
那你告诉我从lwmain2中获取数据插入到lwmain1表中代码应该怎么写呢?条件是lwmain1.dbo.LWnhdd.nh<>lwmain2.dbo.LWnhdd.nh
select 表1.a,表1.b,表1.c,表2.d,表2.e,表2.f
from 表1 join 表2 on 表1.a=表2.c
where 表1.b<>表2.e
还是报无法绑定由多个部分组成的标识符 "lwmain2.dbo.LWnhdd.nh"。 这个错误啊,哪里的问题啊
( 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 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)