Blog Post

Azure Synapse Analytics Blog
3 MIN READ

Remotely run DDL and DML in Synapse from a SQL Managed Instance using Linked Servers

pedrorebelo's avatar
pedrorebelo
Icon for Microsoft rankMicrosoft
Mar 01, 2021
Imagine you have a SQL Managed Instance and a SQL Dedicated Pool. Now imagine that for some reason you need to run a SELECT, INSERT, UPDATE or even a CREATE TABLE on your SQL Dedicated Pool but execu...
Updated Feb 23, 2021
Version 1.0
Synapse SQL
Wenliang's avatar
Wenliang
Copper Contributor
Feb 24, 2023

How to batch insert?

EXEC ('INSERT INTO [database].[Schema].[table] (row1, row2) SELECT r1,r2 form [mylocalserver].[database].[Schema].[table]') AT [LinkedServerName]


[mylocalserver].[database].[Schema].[table] doesn't exist LinkedServer

How to batch insert the data of my local table into the table in linkserver