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

0 vote206 views2 answers
Greater than sql server
SQL
2 votes278 views2 answers
Set value to null sql
SQL
4 votes190 views1 answer
Find tables with column name in sql
SQL
0 vote187 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
0 vote211 views2 answers
How to see table associated with a schema in sql
SQL
1 vote154 views1 answer
Oracle boolean to varchar
SQL
0 vote191 views1 answer
Sql server query database space available
SQL
0 vote188 views1 answer
Oracle sql log to console
SQL
1 vote188 views1 answer
Sql trigger before delete
SQL
1 vote197 views1 answer
Find a column in all tables postgres
SQL