|
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 |
Newsgroups: microsoft.public.sqlserver.programming
From: "Michael Abraham" <mabraha...@newsgroup.nospam>
Date: Fri, 10 Feb 2006 09:48:24 -0500
Local: Fri 10 Feb 2006 14:48
Subject: Guaranteed consecutive identity values
If I do a INSERT INTO <table> SELECT ... and <table> has an identity column
with an increment equal to 1, does SQL/Server 2000 and/or SQL/Server 2005 guarantee that the identity values generated for a single successful INSERT of this type will be consecutive. So if I do an INSERT INTO ... SELECT which inserts, for example, 17 rows, am I guaranteed that the identity values assigned will be N, N+1, N+2, ..., N+16. That is, is it guaranteed that simultaneous INSERTs on other connections Thanks, Mike You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||