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

2 votes267 views2 answers
Mysql all columns
SQL
0 vote313 views1 answer
Mysql collation portugues brasil
SQL
0 vote292 views1 answer
T-SQL Never ending DELETE
SQL
7 votes273 views2 answers
N highest salary in sql
SQL
0 vote294 views1 answer
Split string by comma in sql server
SQL
5 votes309 views2 answers
Postgresql add not null constraint
SQL
3 votes310 views1 answer
Sql print all names that start with a given letter
SQL
0 vote311 views1 answer
Modifier une valeur sql
SQL
0 vote274 views1 answer
Grant access on table in oracle
SQL
0 vote301 views2 answers
Mysql where in maintain order group_concat
SQL