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 vote204 views1 answer
Select tables with name like mysql
SQL
0 vote220 views1 answer
Hallo
SQL
0 vote243 views1 answer
How to check rollback status in oracle
SQL
1 vote241 views1 answer
Postgresql append array
SQL
6 votes264 views2 answers
Mysql check auto increment value
SQL
1 vote241 views1 answer
Float precision in psql
SQL
0 vote199 views1 answer
Get the previous column of a table in mysql
SQL
0 vote197 views1 answer
T sql return on letters only
SQL
0 vote168 views1 answer
Store query result in variable sql
SQL
1 vote180 views1 answer
Real world example of nosql
SQL