How to both update and select in a same operation

Question

How do I do this in TSQL? : How UPDATE and SELECT at the same time

Answer 1

The TSQL equivalent of the answer in the linked question would be something like

UPDATE [table]
SET foo=1
OUTPUT INSERTED.*, DELETED.*
WHERE boo=2

In an update statement you can use INSERTED to get the "after" values and DELETED the "before" values.

Answer 2

You're looking for the OUTPUT clause.