如何在链接的服务器表中插入一行? [英] How to insert a row into a linked server table?

问题描述

我有一个连接的服务器SourceServer，有一个链接服务器TargetServer.

I have a server SourceServer I am connected to which has a linked server TargetServer.

insert语句应如何显示(我需要引用链接服务器，数据库，名称空间，表):

How should an insert statement looks like (I need to reference Linked server, database, namespace, table):

//Connected to [SourceServer]

USE [SourceDatabase]

DECLARE @HelloWorld NVARCHAR(255)

SELECT @HelloWorld = Name From dbo.Names where Id = 1

INSERT INTO [TargetServer].[TestDatabase].dbo.TestTable (Name)   VALUES (@HelloWorld)

此语句执行例外:

Too many prefixes.

更新:以上语法工作正常，问题是用于连接到链接服务器的sql用户的密码已过期:)

推荐答案

INSERT INTO [TargetServer].[TestDatabase].[dbo].TestTable (Name)
SELECT Name From [SourceServer].[SourceDatabase].[dbo].[Names] where Id = 1

这篇关于如何在链接的服务器表中插入一行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！