I've got an interesting constraint I'm trying to add to our database. I can do with with triggers, but am curious if there is a more elegant way to do this in T-SQL (SQL2005, FWIW) We have two related ...

MySQL table primary keys and unique indexes prevent multiple rows with the same index from being added to the table. If you try to insert a duplicate row with a ...

My table is as follows: I have a candidate key using columns A-E. This is too many, but column A is very helpful to keep in each table that references it, so I want to generate a surrogate key using ...