Linked server delete openquery

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)

Source: stackoverflow.com

Similar codes

1 vote268 views1 answer
Drop df constraint sql server
SQL
12 votes268 views4 answers
Mysql ifnull
SQL
10 votes263 views1 answer
Create table oracle
SQL
2 votes256 views4 answers
How to find 2nd highest salary in mysql
SQL
1 vote264 views1 answer
Sql avg group by
SQL
1 vote277 views1 answer
Mysql datetime with timezone offset
SQL
2 votes292 views1 answer
Metasploit start postgresql
SQL
0 vote306 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote280 views3 answers
Duplicate row mysql
SQL
0 vote290 views1 answer
Mysql change default collation
SQL