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 vote213 views1 answer
Connect laravel to mysql on mac
SQL
0 vote230 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
31 votes211 views4 answers
Mysql grant execute
SQL
0 vote198 views1 answer
SQL isnumeric DB2
SQL
0 vote221 views1 answer
Sql server alter table add column tinyint
SQL
6 votes198 views2 answers
Insert into select mysql
SQL
0 vote229 views2 answers
T sql null or empty string
SQL
9 votes181 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote238 views2 answers
How to get max from each department in sql
SQL
0 vote207 views1 answer
How to fetch unique records from two tables
SQL