On Sunday 19 October 2008 02:04:29 pm Amir Michail wrote: > On Sun, Oct 19, 2008 at 5:00 PM, Peter Ondruška > > <[EMAIL PROTECTED]> 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
