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 vote255 views1 answer
What is the use of index in mysql table
SQL
0 vote262 views1 answer
Flask sqlalchemy session delete
SQL
0 vote248 views1 answer
How to create an SQL save method in ruby
SQL
0 vote247 views1 answer
Tsql default value when no value returned by query
SQL
0 vote266 views1 answer
Psql generate id in existing database
SQL
13 votes279 views5 answers
Alter table query sql server change column
SQL
1 vote255 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote249 views2 answers
Database owner can't create new tables postgres
SQL
0 vote260 views1 answer
Mysql multiple count
SQL
0 vote248 views1 answer
Oracle db get table sizes
SQL