Re: SQL: AS IDENTITY - ORDER vs. NO ORDER

[Dan <dan27649@xxxxxxxxx>]

So, this only affects inserts occurring in multiple jobs?  The
documentation was less than clear on that.

- Dan

On Fri, Aug 18, 2017 at 1:18 AM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
wrote:

> If multiple insert statements with multiple rows are executed at the same
> time, ORDER / NO ORDER handles whether all rows form a single insert get a
> subsequent identity value or if the identity column value of both inserts
> can be mixed.