I have 17 records in a table, with a key of "10". I want to clone these, but have the key as "12", but keep all other field info the same.

Using SQL, how would I do this ?

insert into TableA (Field A,Field B etc)
values (select * from TableA where key = 10)

... wouldn't work as theres no way of saying "but make the keys 12 and not 10.

I guess this is probably a simple question, but I can't find an answer.

Can anyone help ?