1、The key manager encapsulates the surrogate key generation function.
2、You need to generate unique values for the surrogate key.
3、This article described three approaches to implementing a surrogate key as primary key.
4、Many large applications use the key manager method to maintain the surrogate keys for all tables.
5、It focused on how to generate unique consequent values for the surrogate key.
6、The IDENTITY function is a good solution for a surrogate key function in most cases.
7、The surrogate key values start with a number, for example "1", for the first row of the table, and is incremented by one for each row thereafter.
8、Identifiers may use surrogate keys.
