I have a PHP page that connects to an Access Database. Basically, the user enters text on the page and the info is entered ito the database once the submit button is pressed. The question "how do I remove duplicates?" is asked so often in the SQL Server newsgroups, that I think there needs to be more recommendations in database articles and books regarding the importance of data integrity, and how to protect your data through primary keys and unique constraints.
Bookmarks