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 vote126 views1 answer
Sqlcl format
SQL
0 vote120 views1 answer
Sql insert query list of dictionaries
SQL
11 votes107 views2 answers
Mysql set safe mode off
SQL
10 votes162 views2 answers
Doublon sql
SQL
8 votes105 views3 answers
Oracle auto_increment
SQL
1 vote109 views2 answers
Mysql update table from another table
SQL
1 vote107 views1 answer
Random name function in mysql for nvarchar
SQL
1 vote100 views1 answer
Oracle db create new schema
SQL
1 vote107 views2 answers
Pad zero sql server
SQL
0 vote106 views1 answer
Mysql select distinct date from timestamp
SQL