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 vote165 views1 answer
Starting mysql shell lampp ubuntu
SQL
1 vote189 views2 answers
Sql queries practice
SQL
1 vote209 views1 answer
Tsql create unique index composite
SQL
0 vote168 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote189 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
0 vote198 views1 answer
Sql order by number not ordered
SQL
0 vote206 views1 answer
Ms sql print more than 1 variable
SQL
4 votes171 views2 answers
Show all database inside postgresql
SQL
0 vote176 views1 answer
Bitmap join index
SQL
3 votes170 views1 answer
Oracle apex warning message
SQL