Proper constraints and data validation are the cornerstone of robust applications. They enforce explicit contracts between your database and the applications that rely on them reducing the number of contingencies that your application code needs to account for. In this article, I address a specific variant of the uniqueness constraint that is a little tricky [...]
Filed under: Technology Tips | Tagged: Constraint, Index, Null, SQL, SQL2005, SQL2008, Unique | 2 Comments »
