SQL Server 2005 T-SQL New Features: OUTPUT

SQL Server 2005 offers a much more convenient way of determining the system-generated values by attacking the problem at the source, within the INSERT statement itself. By adding an OUTPUT clause to an INSERT statement, it is easy to determine all values created during an INSERT; not just IDENTITY values, but also, values created by function calls such as GETDATE() or computed columns. Read on...