Thomas Bratt
Reputation: 51832
Is there an SQL Server equivalent to Oracle's RETURNING statement?
Is there an SQL Server equivalent to Oracle's RETURNING statement?
I'm wondering if the OUTPUT clause would help.
Upvotes: 0
Views: 1329
Answers (1)
Quassnoi
Reputation: 425471
Yes, the OUTPUT clause is exactly what you need.
In SQL Server 2008 you can even chain the output clauses.
Upvotes: 3
Related Questions
- Does Oracle support RETURNING in an SQL statement?
- SQL execute return of select
- Possible to Return Set of Values in SQL Server without Return Value?
- 'Return' column name
- Oracle's RETURNING INTO :variable equivalent using SQL Server
- MSSQL - Return Select
- Returning oneliner from SQL Server query
- perform operation on return value
- sql server query to return a value
- The Return statement