出错:无法绑定由多个部分组成的标识符
报错:无法绑定由多个部分组成的标识符
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
报错为---无法绑定由多个部分组成的标识符 "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
报错为---无法绑定由多个部分组成的标识符 "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)