In SQL Server 2000, I want to apply a check constraint on a column type varchar that it is not duplicated. Could someone help me out with this?
Also, should I just make this column the primary key instead of an identity field being the primary key?
What is the performance difference by applying the constraint rather then just making it the primary key?
Mike BTry using a unique constraint !!
Showing posts with label duplicated. Show all posts
Showing posts with label duplicated. Show all posts
Sunday, March 11, 2012
Check Constraint?
Subscribe to:
Posts (Atom)