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 vote233 views2 answers
Last working day in week date function in sql
SQL
2 votes221 views2 answers
Mamp connect mysql terminal
SQL
0 vote247 views1 answer
Print boolean in plsql
SQL
0 vote208 views1 answer
Postgresql parse json array
SQL
1 vote242 views1 answer
Retrieve meaning
SQL
0 vote217 views3 answers
Drop multiple columns in sql
SQL
0 vote237 views1 answer
How to check which table has data in mysql
SQL
0 vote241 views1 answer
Report in database
SQL
1 vote237 views1 answer
How to select multiple columns from different tables in mysql
SQL
0 vote230 views1 answer
Select from column mysql
SQL