Understanding SQL Server Identity Values: The Pros, Cons, and Workarounds

How to Automatically Set 'id' Using MySQL Triggers or UUIDs Instead of AUTO_INCREMENT