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 vote266 views1 answer
Sql describe
SQL
1 vote290 views1 answer
Psql filed name alter
SQL
4 votes273 views1 answer
Oracle table statistics last analyzed
SQL
0 vote286 views1 answer
Sql select duplicates based on two columns
SQL
0 vote280 views1 answer
Mysql grant access to one database
SQL
1 vote306 views2 answers
Sql server backup table
SQL
11 votes298 views1 answer
Ddl view
SQL
16 votes281 views2 answers
Sql exists
SQL
3 votes277 views1 answer
Ssh check mysql version
SQL
3 votes311 views1 answer
Sql double index
SQL