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

linked server delete openquery

Code with bulbul answered on August 2, 2021 Popularity 3/10 Helpfulness 2/10

answer linked server delete openquery

linked server delete openquery

Comment

DECLARE @OPENQUERY nvarchar(4000), @TSQL nvarchar(4000), @LinkedServer nvarchar(4000);
DECLARE @name nvarchar(10) = 'Y4081';
SET @LinkedServer = 'linkedserver'
SET @OPENQUERY = 'DELETE FROM OPENQUERY('+ @LinkedServer +', '''
SET @TSQL = 'SELECT * FROM [MyDataBase].[dbo].[MyTable] 
WHERE Name = '+@name+' '')'
EXEC(@OPENQUERY+@TSQL)

Popularity 3/10 Helpfulness 2/10 Language sql

Source: stackoverflow.com

Tags: linked-server openquery sql

Link to this answer
Share Copy Link