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

3 votes200 views1 answer
System.debug apex
SQL
2 votes261 views1 answer
Mysql select true or false
SQL
0 vote223 views1 answer
Sql last time database was accessed
SQL
1 vote246 views1 answer
STOP message of how many rows affected sql
SQL
12 votes229 views6 answers
How to install sqlite3 in python
SQL
0 vote205 views1 answer
Trim sql oracle
SQL
19 votes242 views5 answers
Display table in sql
SQL
0 vote217 views1 answer
Postgresql delete multiple rows
SQL
3 votes249 views4 answers
Truncate syntax in sql
SQL
0 vote179 views1 answer
How to check oracle index table
SQL