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 vote117 views1 answer
Exclude last comma separated string mysql
SQL
2 votes122 views1 answer
Add new column not null sql server
SQL
15 votes115 views4 answers
Mysql where value is null
SQL
0 vote124 views1 answer
Stratified sampling sql
SQL
10 votes77 views1 answer
Oracle view dependencies
SQL
3 votes117 views2 answers
Mysql time
SQL
-1 vote128 views4 answers
Restart mysql server ubuntu
SQL
0 vote117 views1 answer
Oracle free up space in tablespace
SQL
19 votes83 views1 answer
Sqrt(-1)
SQL
0 vote107 views1 answer
View acl table oracle
SQL