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 vote186 views2 answers
Mysql type conversion
SQL
10 votes177 views3 answers
Insert into auto increment mysql
SQL
1 vote214 views1 answer
Mysql login console
SQL
0 vote193 views1 answer
Postgres in operator with comma separated values
SQL
0 vote162 views1 answer
Django how to get query result count
SQL
0 vote194 views1 answer
Oracle DROP PROGRAM
SQL
1 vote212 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
1 vote216 views1 answer
STOP message of how many rows affected sql
SQL
0 vote207 views1 answer
How to get first 10 records of a table in mysql
SQL
13 votes203 views4 answers
Mysql select last 10 rows
SQL