database
Get flash to fully experience Pearltrees
source
By Bill Graziano on 4 May 2005 | 18 Comments | Tags: Queries , User Defined Functions
Microsoft SQL Server - Using CROSS APPLY in SQL Server 2005 - SQ
Library of Free Data Models
This is called a surrogate key, but there is a 'gotcha' which can be deadly. It is all too easy to enter the same record twice. Therefore you must always be sure to enforce a unique constraint on the natural key. Luckily this is easy to do in Access which can be a good basis for clarifying your design and constraints. Why do I do this for free ?