title: Where does SQL output values when OUTPUT clause is used in PHP string variable?
body: <p>I am trying to retrieve an auto-incremented value that is created upon insertion. This ID value will be used in a SELECT statement later, so it would be nice to know what it is when I insert instead of writing another query. The problem is that I don't know where OUTPUT clause outputs it. The query is in the form of a PHP string variable. </p>
  
  <p>I'm new to SQL and PHP, so I'm not really sure what to try. I just need some help understanding.</p>
  
  <pre><code>$query = "INSERT INTO Table1 (orderNumber, revisionNumber, creationDate...)"
  . " OUTPUT Inserted.ID"
  . " VALUES (blah, blah, blah...)";
  execute_query($query);
  </code></pre>