title: Unclosed quotation mark after the character string ')' - OPENQUERY
body: <p>I have the following query, executed with <code>OPENQUERY</code> : </p>
  
  <pre><code>    DECLARE @DOMAIN NVARCHAR = N'XXX'
      DECLARE @QUERY NVARCHAR(MAX)= '
      SELECT * FROM OPENQUERY( [XX\XX],''
  
      SELECT  CONCAT(CONCAT([Firstname],''),[Lastname]) AS [Owner]
             FROM [Employee] '')'
      EXECUTE XX_executesql @QUERY
  </code></pre>
  
  <p>When I execute , I get this following error : </p>
  
  <blockquote>
    <p>Msg 102, Level 15, State 1, Line 4 Incorrect syntax near ')'. Msg 105,
    Level 15, State 1, Line 5 Unclosed quotation mark after the character
    string ')'.</p>
  </blockquote>