Posted by Mike C# on 10/02/30 11:50
"Tony Rogerson" <tonyrogerson@sqlserverfaq.com> wrote in message
news:e6timt$hna$1$8300dec7@news.demon.co.uk...
> This might help from the SQL Engine team blog...
>
> http://blogs.msdn.com/sqltips/archive/2005/07/20/441053.aspx
>
> Its point 4, the identities are calculated in the right order just not
> inserted but the insert order shouldn't matter if the identities are
> calculated in the correct order.
I noticed the blogger states "*most* of the rules are valid for SQL 2000
too", though he doesn't specify which ones.
Navigation:
[Reply to this message]
|