SQL: Output-insert, get the identit value of batch Insert at a time.

When we insert a row of records, we can use function: scope_identity () to obtain

However, when we insert a group of data, if we want to obtain the idntity value of this group of inserted data, we can get it through the following SQL:

 Declare   @ TMP   Table (ID Int , Name Char ( 10  ))  Declare   @ Test1   Table (ID Int   Identity   Primary  Key  , Name  Char ( 10  ))  Insert   @ Test1  Output inserted.  *  Into   @ TMP  Select  A. Name  From  (  Select  '  Angelia1  '    As  Name  Union   All  Select   '  Angelia2  '   As  Name  Union   All  Select   '  Angelia3 '   As  Name)  Select   *   From   @ Test1  Select   *   --  , Row_number () over (order by ID) as num  From   @ TMP