Question came up on Darcy Whites listserv and thought I'd throw it around here.

What is best way to generate a new primary key?

I use a udf that stores the pointer, and order. Then sets the order to the primary tag, then goes bottom and increments, then returns order and pointer and returns back new key. Fairly fast udf since it doesn't do any locate etc but if anyone has better code/ideas let me know.

TIA