This is copied verbatim from the MSDN page about @@IDENTITY : "After an INSERT , SELECT INTO , or bulk ...
stackoverflow.com