adding unique keys

Giganews Newsgroups
Subject: adding unique keys
Posted by:  HandersonVA (handerson…@hotmail.com)
Date: 22 Aug 2006

Would anyone please instruct how to prevent the duplicate record by
setting the unique keys on the ms sql server? i've been checking the
duplicate record as front-end and i found out if there is an internet
delay or some other reasons, it has a chance to store the duplicated
data into the database. so i realized it has to be done on the back-end
side.
for example, if i have three columns (office code, office id, office
section) as a unique key, how can i setup this? thanks in advance.

Replies