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.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan
Sent: Freitag, 18. August 2017 01:37
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: SQL: AS IDENTITY - ORDER vs. NO ORDER
(Sorry, fat-fingered)
Continuing on my SQL education regarding the "GENERATED ALWAYS AS IDENTITY"
clause, I found the ORDER / NO ORDER attribute, and am wondering what this
means. I had presumed that my sequence field would be incremented by one in
the order the associated records are inserted into the table, but, it would
appear by this attribute that I need to explicitly specify it. The
reference says the default is NO ORDER. I'm wondering why you wouldn't
always want such a field to be incremented in order of its record being
written to the table. If ORDER is specified, does that have an impact on
the IDENTITY CACHE?
- Dan
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
