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 vote196 views1 answer
Concatenate columns in table
SQL
2 votes225 views1 answer
Oracle trace file
SQL
1 vote206 views2 answers
Mysql remove first and last character from string
SQL
16 votes209 views1 answer
Mysql mediumint max value
SQL
1 vote202 views1 answer
How to remove identity from a column in sql server
SQL
3 votes208 views1 answer
Laravel database Using Named Bindings
SQL
11 votes216 views1 answer
Sql insert multiple rows from select
SQL
1 vote184 views1 answer
Avg mysql
SQL
6 votes226 views3 answers
What is where in sql
SQL
-1 vote215 views1 answer
How to open blade file from blade in laravel
SQL