How do I create Constraint Expressions for MSSQL 2005?
Posted on 2007-08-04
I am running MSSQL Server 2005 Standard Edition on Windows Server 2003 Enterprise Edition.
I am using the SQL Server Management Studio included witth the MSSQL 2005 Standard installation running on the Database Computer and using the login credentials from the Currently Logged In Enterprise Admins Account.
I open up a table from the database Tree and select to modify it.
Right clicking on a row will allow me to edit constraint expressions.
I have previously use expressions like ComumnX < 8 but i am having trouble with unique expressions.
How do I create an expression that checks for duplicates in a single column, how do I create an Expression that checks for duplicate combinations of a couple rows ie. no 2 rows can have the same first AND last name, and where can I find more information on how to create the expressions?