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 vote372 views1 answer
Mysql shell ERROR: Not connected.
SQL
-1 vote305 views3 answers
Ubuntu install mssql
SQL
0 vote374 views1 answer
Java mysql swing example
SQL
0 vote372 views2 answers
Mysql decimal remove trailing zeros
SQL
-1 vote355 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote392 views1 answer
Get clob size oracle
SQL
3 votes361 views2 answers
How to modify rows in SQL Server
SQL
0 vote369 views2 answers
Timing sql queries
SQL
0 vote353 views1 answer
Ksql quickstart docker
SQL
0 vote363 views1 answer
T-SQL MERGE with condition what is not matched?
SQL