How to make SQL insert script over-write duplicate entry?

You'd probably need to do a search query first to determine whether its a duplicate record and then use an UPDATE instead to change the existing details.