Linked-Server - SQL Server for MySQL - Variable execution.

[Claudinei Silva]

Group

How would you run script 1 without error, where its base would be the same as script 2.
Where in this case it would be running inside a SQL Server, using linked-Server. But then there would be an error. (script 1)


-- script 1

select
*
from
openquery([LINKED_MYSQL],
'
set @dsNome = ''Oi'';

select @dsNome;
'
)


-- script 2

select
*
from
openquery([LINKED_MYSQL],
'
select ''Oi''
'
)