title: How to select and update in one query?
body: <p>I need to return a row:</p>
  
  <pre><code>.NET[tableReturn] = select top(1) * from [table] where x = 0 order by desc
  </code></pre>
  
  <p>but at the same time I need to update it:</p>
  
  <pre><code>update [table] set x = 1 where [id] = .NET[tableReturn].[id]
  </code></pre>
  
  <p>and need all data of this row</p>
  
  <p>It is possible in the same query?</p>