UPDATE and SELECT a row in the same transaction

Question

Is it possible to UPDATE a row and then SELECT the updated data from the very same row inside the same transaction without fear of a deadlock?

Answer 1

Use OUTPUT clause to do this.

Update table_name
set col1='some_value'
output inserted.*