postgreSQL RETURNING clause VS Microsoft SQL Server

Question

I moving from different SQL languages and I want to UPDATE a table and to return some of its columns as below.

Here is how I done it in postgreSQL -

UPDATE account
SET last_login = CURRENT_TIMESTAMP
RETURNING email, created_on, last_login

how do I return certain columns in MS SQL ?

Use the OUTPUT clause. This can return both the original and new values in an UPDATE operations — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Jan 8, 2021 at 10:46
@PanagiotisKanavos I tried but I can't seem to find the correct syntax. — user13279074
– user13279074, Commented Jan 8, 2021 at 10:52
Did you check the docs? Examples C through G are UPDATEs with OUTPUT. What did you try? — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Jan 8, 2021 at 11:15

revoua · Accepted Answer · 2021-01-08 11:05:40Z

4

UPDATE account
SET last_login = CURRENT_TIMESTAMP
OUTPUT INSERTED.*, DELETED.last_login

answered Jan 8, 2021 at 11:05

revoua

2,0691 gold badge23 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1