Is it possible to insert a record into a keyed table such that you automatically replace the record if it already exists? Or do you have to delete it first, and then insert it? If it can be done, what is the syntax?
p.s. I'm on MS SQL Server.