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 vote111 views2 answers
Sql last updated
SQL
0 vote130 views1 answer
Mysql root localhost run
SQL
22 votes126 views3 answers
Remove all records from table mysql
SQL
1 vote120 views3 answers
Default password of mysql
SQL
1 vote131 views1 answer
Sql random sampling per group
SQL
1 vote118 views1 answer
Mariadb get column names from table
SQL
0 vote114 views1 answer
Multiple left join mysql
SQL
0 vote114 views1 answer
Back up stored procedures mysql
SQL
2 votes123 views3 answers
Sql truncate table
SQL
0 vote129 views1 answer
Mysql join column order By and group By
SQL