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

-2 votes179 views1 answer
Group functions in sql
SQL
0 vote173 views1 answer
Except in sql alchemy
SQL
1 vote180 views2 answers
Sql queries practice
SQL
2 votes180 views1 answer
Oracle kill job by sid
SQL
-1 vote185 views1 answer
Default username and password for oracle 11g
SQL
0 vote130 views1 answer
Mysql select top 2
SQL
0 vote194 views1 answer
Delete hangfire retries list
SQL
0 vote173 views1 answer
Mysql table variables
SQL
0 vote188 views1 answer
How to convert external table to managed table in hive
SQL
5 votes225 views2 answers
How to ascending order in sql
SQL