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? Amir > > On Sun, Oct 19, 2008 at 10:52 PM, Amir Michail <[EMAIL PROTECTED]> wrote: >> >> Hi, >> >> I was wondering what is the most efficient way to get the max >> automatically generated row id. >> >> select max(...) is slow. >> >> Amir >> >> -- >> http://chatbotgame.com >> http://numbrosia.com >> http://twitter.com/amichail > > -- http://chatbotgame.com http://numbrosia.com http://twitter.com/amichail
