从此链接尝试解决方案1 ​​



http://***.com/questions/3502269/how-to-insert-table -values-from-one-database-to-another-database [ ^ ]

try solution 1 from this link

http://***.com/questions/3502269/how-to-insert-table-values-from-one-database-to-another-database[^]

继续解决方案1 ​​...您的代码

Further to solution 1 ... your code

insert into [example.dyndns.org\SERVER].[MainShopWork].[dbo.Inv_Brand]
 select * from temp

的code-keyword>表示您有一个名为dbo.Inv_Brand的表。



我怀疑你实际有一个表 Inv_Brand 为架构/表所有者 dbo 所以你的代码应该读

implies that you have a table called "dbo.Inv_Brand".

I suspect you actually have a table Inv_Brand for the schema/table owner dbo so your code should have read

insert into [example.dyndns.org\SERVER].[MainShopWork].[dbo].[Inv_Brand]
 select * from temp

顺便说一下是给出错误应该跟着错误的措辞 - 我们无法看到你的屏幕或通过你的眼睛看到问题是什么。

By the way "is giving error" should have been followed by the wording of the error - we can't see your screen or see through your eyes to find out what the problem is.