N. 使用 OPENQUERY 函數將資料插入遠端資料表 下列範例會指定 OPENQUERY 資料列集函式,以將資料列插入至遠端資料表。 上一個範例所建立之連結的伺服器名稱會用於這個範例。 適用於:SQL Server 2008 (10.0.x) 和更新版本。 SQL 複製 INSERT OPENQUERY (MyLinkServer, 'SELECT Name, GroupName FROM AdventureWorks...
N. 使用 OPENQUERY 函數將資料插入遠端資料表 下列範例會指定 OPENQUERY 資料列集函式,以將資料列插入至遠端資料表。 上一個範例所建立之連結的伺服器名稱會用於這個範例。 適用於:SQL Server 2008 (10.0.x) 和更新版本。 SQL 複製 INSERT OPENQUERY (MyLinkServer, 'SELECT Name, GroupName FROM AdventureWorks...
INSERT INTO MyLinkServer.AdventureWorks2022.HumanResources.Department (Name, GroupName) VALUES (N'Public Relations', N'Executive General and Administration'); GO N. 通过使用 OPENQUERY 函数向远程表插入数据 下面的示例通过指定 OPENQUERY 行集函数向远程表插入一行。 在之前例子中创建的链接服务器名称用于此...
N. Inserting data into a remote table by using the OPENQUERY function The following example inserts a row into a remote table by specifying the OPENQUERY rowset function. The linked server name created in the previous example is used in this example. Applies to: SQL Server 2008 (10.0.x) an...
N. Inserting data into a remote table by using the OPENQUERY function The following example inserts a row into a remote table by specifying the OPENQUERY rowset function. The linked server name created in the previous example is used in this example. Applies to: SQL Server 2008 (10.0.x) an...
N. Inserting data into a remote table by using the OPENQUERY functionThe following example inserts a row into a remote table by specifying the OPENQUERY rowset function. The linked server name created in the previous example is used in this example.Applies to: SQL Server 2008 (10.0.x) and ...
INSERT a row into a remote table by specifying the OPENQUERY rowset function. The linked server name created in the previous example is used in this example.Syntax INSERT OPENQUERY (MyLinkServer, 'SELECT EmployeeName, EmployeeAddress FROM Sample.EmployeeDetails') VALUES ('Ravi', 'Noida');...
B. Inserting data into a remote table by using the OPENQUERY function The following example inserts a row into a remote table by specifying theOPENQUERYrowset function. The linked server name created in the previous example is used in this example. ...
B. Inserting data into a remote table by using the OPENQUERY function The following example inserts a row into a remote table by specifying theOPENQUERYrowset function. The linked server name created in the previous example is used in this example. ...
Inserting data using the OPENQUERY To insert data from a remote database, we can use the OPENQUERY statement. For example, the following SQL command reads the result set of an MDX query executed over a linked server mapping to an SSAS instance and then stores the result into a temp table....