On Sunday 19 October 2008 02:04:29 pm Amir Michail wrote:
> On Sun, Oct 19, 2008 at 5:00 PM, Peter Ondruška
>
> <
peter.ondruska@...> wrote:
> > You want to use identity: Defining an identity column
>
> Yes, but how do you get the max row id efficiently without adding another
> row?
In the particular table, how many rows are you referring to? A few thousand? A
few million? A hundred million?
Do you have an index on the identity column? What's your datatype?
--
kai
www.filesite.org || www.perfectreign.com
Clean out a corner of your mind and creativity will instantly fill it. - Dee
Hock
