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

10 votes318 views4 answers
Primary key sql
SQL
7 votes336 views2 answers
Show size database mysql
SQL
19 votes337 views5 answers
Mysql between date range
SQL
0 vote363 views1 answer
Sql server remove primary key without dropping table
SQL
22 votes403 views1 answer
Mysql workbench
SQL
0 vote324 views1 answer
Drop column from table if exist on live server mysql
SQL
0 vote329 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
0 vote362 views2 answers
Plpgsql
SQL
5 votes322 views2 answers
Update all rows mysql
SQL
0 vote316 views1 answer
Acual month sql
SQL