Breaking News: Grepper is joining You.com. Read the official announcement!

insert into openquery linked server

Rasel Ahmed answered on August 2, 2021 Popularity 3/10 Helpfulness 2/10

answer insert into openquery linked server

related openquery insert into linked server

insert into openquery linked server

Comment

BEGIN
DECLARE @Column1 int = 1
	,@Column2 varchar(12)='Test'
 EXEC ('  
   Insert OpenQuery(LinkServerName,''SELECT Column1,Column2
   FROM TableName'')  
   Values('''+@Column1+''','''+@Column2+'''
 );')  
End

Popularity 3/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: insert-into linked-server openquery sql

Link to this answer
Share Copy Link

Contributed on Jul 28 2022

Rasel Ahmed

0 Answers Avg Quality 2/10

Closely Related Answers

openquery insert into linked server

Comment

INSERT INTO OPENQUERY([Remoteserver]
    ,'SELECT subdirectory, depth, [file] FROM [RemoteDB].[dbo].[files]')
EXEC master.sys.xp_dirtree '\\fileserver\DBBackup', 1, 1;

Popularity 4/10 Helpfulness 3/10 Language sql

Source: stackoverflow.com

Tags: linked-server sql insert-into openquery

Link to this answer
Share Copy Link