Is there an SQL Server equivalent to Oracle's RETURNING statement?
I'm wondering if the OUTPUT clause would help.
Yes, the OUTPUT clause is exactly what you need.
OUTPUT
In SQL Server 2008 you can even chain the output clauses.
SQL Server 2008