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 votes358 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote322 views1 answer
Nueva tabla mysql
SQL
0 vote334 views1 answer
Big table in mysql
SQL
0 vote363 views1 answer
Sql delete caracter list
SQL
0 vote340 views3 answers
Average salary in sql
SQL
2 votes350 views5 answers
Eloquest how to select one specific column in database
SQL
0 vote339 views1 answer
Windows aggregate functions in postgresql
SQL
0 vote360 views1 answer
Mod in sql
SQL
5 votes336 views2 answers
Oracle rename table
SQL
13 votes335 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL