0

Is there an SQL Server equivalent to Oracle's RETURNING statement?

I'm wondering if the OUTPUT clause would help.

Charles
  • 50,943
  • 13
  • 104
  • 142
Thomas Bratt
  • 48,038
  • 36
  • 121
  • 139
  • Related question: http://stackoverflow.com/questions/1074843/is-there-an-oracle-equivalent-to-sql-servers-output-inserted – Thomas Bratt May 21 '10 at 11:46

1 Answers1

3

Yes, the OUTPUT clause is exactly what you need.

In SQL Server 2008 you can even chain the output clauses.

Quassnoi
  • 413,100
  • 91
  • 616
  • 614