title: Using a Variable in OPENROWSET Query
body: <p>I'm having trouble with this query:</p>
  
  <pre><code>SELECT * 
  FROM OPENROWSET(
      'SQLNCLI',
      'DRIVER={SQL Server};',
      'EXEC dbo.sProc1 @ID = ' + @id 
   )
  </code></pre>
  
  <p>Gives an error:</p>
  
  <blockquote>
    <p>Incorrect syntax near '+'.</p>
  </blockquote>
  
  <p>Anyone know why I'm getting this error?</p>