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 vote398 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote296 views1 answer
Fix sqlite3 ruby on rails
SQL
4 votes310 views2 answers
SELECT table_name FROM user_tables;
SQL
8 votes339 views1 answer
My sql version
SQL
0 vote328 views1 answer
How to know if table in rigt or left in sql
SQL
0 vote359 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
0 vote326 views1 answer
Sql use with to get value counts and percentages
SQL
1 vote314 views1 answer
Rermove categories woocommerce sql
SQL
16 votes365 views1 answer
Sqlserver add column to table
SQL
0 vote312 views1 answer
RowDataPacket
SQL