Post a Comment On: Blogpad

-- RecordNumber will now be a unique field ALTER TABLE Clients
ADD CONSTRAINT UN_Clients_RecordNumber
UNIQUE (RecordNumber) -- LocationID, PhoneNumber and StartDate will be unique per row ALTER TABLE Clients
ADD CONSTRAINT UN_Clients
UNIQUE (LocationID, PhoneNumber, StartDate)