title: SQL: Update a row and returning a column value with 1 query
body: <p>I need to update a row in a table, and get a column value from it. I can do this with</p>
  
  <pre><code>UPDATE Items SET Clicks = Clicks + 1 WHERE Id = @Id;
  SELECT Name FROM Items WHERE Id = @Id
  </code></pre>
  
  <p>This generates 2 plans/accesses to the table. Is possibile in T-SQL to modify the UPDATE statement in order to update and return the Name column with 1 plan/access only?</p>
  
  <p>I'm using C#, ADO.NET <code>ExecuteScalar()</code> or <code>ExecuteReader()</code> methods.</p>