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 vote292 views1 answer
Using SQL in rails migration
SQL
1 vote281 views1 answer
Select not matching data from two tables
SQL
4 votes318 views3 answers
Sql drop primary key
SQL
0 vote304 views1 answer
Show create table in postgresql
SQL
2 votes344 views1 answer
Mysql shell insert into
SQL
1 vote325 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote311 views1 answer
Oracle step procedure
SQL
1 vote301 views2 answers
Restart identity cascade
SQL
0 vote308 views1 answer
Copy Table from SQL to CSV
SQL
38 votes355 views6 answers
Alter table mysql
SQL