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
Oracle create package specification
SQL
1 vote273 views2 answers
How to enable error squiggles in vs code
SQL
1 vote297 views1 answer
Increase existing date in sql
SQL
0 vote287 views1 answer
QCompleter con sql
SQL
0 vote226 views2 answers
How to combine two sql queries in one result
SQL
1 vote269 views1 answer
Oracle user last connection date
SQL
1 vote292 views1 answer
Write a query to create an empty table from an existing table?
SQL
0 vote287 views1 answer
C# get sql min date
SQL
1 vote274 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
1 vote304 views1 answer
Show databases mysql docker
SQL