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

3 votes146 views2 answers
Create schema postgres
SQL
0 vote165 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
3 votes164 views1 answer
What is having
SQL
8 votes200 views2 answers
Oracle auto increment primary key
SQL
14 votes139 views2 answers
Oracle add column with default value
SQL
0 vote154 views1 answer
Find duplicate users by email address in mysql
SQL
5 votes136 views1 answer
JBDC
SQL
1 vote131 views1 answer
Oracle sql create view
SQL
-1 vote197 views3 answers
MAKE TABLE FIT in oracle sql
SQL
1 vote143 views2 answers
Begin transaction in sql
SQL