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 vote240 views1 answer
How to to get current date in sql
SQL
1 vote258 views1 answer
Postgresql if 0 then 1
SQL
0 vote269 views1 answer
Sql script to remove default from column
SQL
0 vote229 views2 answers
SQL Server Standard
SQL
0 vote234 views1 answer
Sqlplus change user
SQL
0 vote237 views1 answer
Mysql error 1251
SQL
0 vote375 views1 answer
Sql change a colum to unique
SQL
0 vote238 views1 answer
Mysql read row
SQL
0 vote284 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote226 views1 answer
Insert thai language sql server
SQL