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 vote207 views1 answer
Insert many to many sql
SQL
0 vote206 views1 answer
Install postgresql 12 on debian 10
SQL
1 vote186 views2 answers
Drop table if exists test
SQL
9 votes191 views3 answers
Import DB through mysql console
SQL
0 vote162 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote172 views1 answer
Postgresql transaction discard all
SQL
25 votes175 views6 answers
Import mysql database command line
SQL
0 vote242 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
1 vote186 views1 answer
Describe table in sql
SQL
0 vote208 views1 answer
Como hacer un select entre fechas mysql
SQL