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 vote130 views1 answer
Mariadb LOAD DATA INFILE
SQL
0 vote134 views1 answer
Oracle sql winter time change
SQL
0 vote141 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote145 views1 answer
Unique index in mysql
SQL
-1 vote143 views1 answer
How to change the auto increment in existing table mysql
SQL
0 vote106 views2 answers
Delete the last item in a table sql
SQL
2 votes148 views1 answer
Mysql select default if null
SQL
1 vote124 views1 answer
Can not connect to mysql server
SQL
1 vote85 views1 answer
File /etc/init.d/mysql not exists
SQL
0 vote145 views1 answer
Sql combine results from two tables
SQL