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 vote142 views3 answers
Postgresql connect to database
SQL
0 vote164 views1 answer
What is top n result in sql
SQL
2 votes221 views1 answer
Tsql copy table
SQL
12 votes142 views3 answers
Duplicate a column in sql
SQL
16 votes154 views3 answers
Update table from another table
SQL
12 votes139 views2 answers
Delete all data in neo4j
SQL
0 vote139 views1 answer
Oracle list of long running queries
SQL
1 vote143 views1 answer
Get rows affected mysql python
SQL
0 vote138 views1 answer
Stuff in sql server
SQL
6 votes155 views4 answers
Remove spaces sql server
SQL