|
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: "Dave Frommer" <a...@spam.com>
Date: Fri, 10 Feb 2006 10:20:09 -0500
Local: Fri 10 Feb 2006 15:20
Subject: Re: Guaranteed consecutive identity values
No, that is not guaranteed.
news:epPcMElLGHA.4064@TK2MSFTNGP10.phx.gbl... > 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.
| |||||||||||||