Good to see examples of the output clause.

The @@identity problem should be a no-problem, if people just remembered to use scope_identity() instead. It will return the correct identity value to you. No identities from triggers.

Just remember that using any kind of @@identity or scope_identity() will still require some RBAR on multi line inserts.