请教：跨服务器的多表操作

[hsanjin]

//创建链接服务器
EXEC sp_addlinkedserver 'LinkName','','SQLOLEDB','20.10.1.22'
EXEC sp_addlinkedsrvlogin 'LinkName','false',NULL,'sa',''

insert into Table2
select LinkName.Database.dbo.Table2.*
from LinkName.Database.dbo.Table1,LinkName.Database.dbo.Table2
where LinkName.Database.dbo.Table1.dt>='1900-10-01' and LinkName.Database.dbo.Table1.dt<='2009-10-31'
and LinkName.Database.dbo.Table1.RecNo=LinkName.Database.dbo.Table2.RecNo

“创建链接服务器”成功，但执行插入操作时提示
“数字 名称 'LinkName.Database.dbo.Table2'包含的前缀数目超过了最大值。最大值为 3。”

如何解决这种跨服务器的多表操作，谢谢！

[中国风]

insert into Table2
select b.*
from LinkName.Database.dbo.Table1 AS a,LinkName.Database.dbo.Table2 AS b
where a.dt>='1900-10-01' and a.dt<='2009-10-31'
and a.RecNo=b.RecNo

[中国风]

用別名再連接

[Mr_Nice]

insert	into Table2
select	b.*
from	LinkName.Database.dbo.Table1 a,LinkName.Database.dbo.Table2 b
where	a.dt>='1900-10-01' and a.dt<='2009-10-31'
and	a.RecNo=b.RecNo

[htl258_Tony]

[Quote=引用 1 楼 roy_88 的回复:]
SQL code
insert into Table2
select b.*
from LinkName.Database.dbo.Table1 AS a,LinkName.Database.dbo.Table2 AS b
where a.dt>='1900-10-01' and a.dt<='2009-10-31'
and a.RecNo=b.RecNo
[/Quote]UP

[ask_chang]

用別名再連接

[xiecw1979]

上述链接服务器好了后，就可以操作下面的语句了
insert into 数据库.Table2
select * from [xx.xx.xx.xx].[数据库].dbo.[b.*]

[baobaoaini999]

搞的很厉害！