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 views5 answers
Select concat alter table mysql
SQL
0 vote134 views1 answer
How to delete python anywhere mysql database
SQL
1 vote133 views1 answer
Base64 encode sql server
SQL
46 votes200 views4 answers
Create column sql
SQL
0 vote137 views1 answer
Create table split string function in sql server
SQL
1 vote146 views1 answer
Increase date by one day in sql oracle
SQL
0 vote130 views1 answer
Watch mysql command line
SQL
10 votes153 views2 answers
Select nextval from sequence oracle
SQL
-1 vote124 views2 answers
Get day in sql
SQL
0 vote127 views1 answer
Android sqlite get rows count
SQL