Identity Columns Aren’t Automatically Primary Keys
Identity columns (automatically incrementing numbers) are fairly common in SQL Server, having the merit of simplicity and pretty good performance. As such they are often used as primary keys, and that’s fine too (unless you subscribe to natural keys at all costs). But, they aren’t automatically primary keys. If you want it to be the […]Read more "Identity Columns Aren’t Automatically Primary Keys"