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 vote316 views1 answer
How to find total working hour in sql
SQL
4 votes275 views1 answer
Update table from another table oracle
SQL
6 votes282 views1 answer
Oracle rank() over (partition)
SQL
0 vote282 views4 answers
Sql year
SQL
0 vote311 views1 answer
Generate random & unique mysql string
SQL
10 votes250 views1 answer
Oracle view dependencies
SQL
3 votes315 views1 answer
Create a table with an id in mysql
SQL
0 vote330 views1 answer
SQL server datetime compare
SQL
0 vote290 views3 answers
Find below average salary in sql
SQL
3 votes297 views1 answer
Dbms_scheduler drop_job
SQL