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

6 votes382 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote397 views1 answer
Apt install sql server
SQL
2 votes360 views1 answer
Postgresql change value in column
SQL
0 vote377 views1 answer
Sql server for loop
SQL
0 vote326 views1 answer
Oracle sql date summer time
SQL
0 vote382 views2 answers
Select last 30 days sql
SQL
0 vote365 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote387 views1 answer
Get primary key of table
SQL
8 votes340 views5 answers
Alter table add column with default value
SQL
0 vote368 views1 answer
Psql list rules
SQL