Identity field synchronization
hi this is kavita
anybody tell me how identity field work.
I m using insert table1 select top 500 * from table2
if 100 of request made at same time then will identity value like 1-300 for one session,301-600 for second session etc or something else?