I am interested in methods of allocating ID's in multiple related table databases.
I mean,what is a good solution to generate them..using DBMS AutoIncrements or reading them from the table and generating a new one?
I know that MS SQL has something called @@identity; Can this be used in generating unique IDs?
I'm interested in your opinions.