Duplicate all rows in sql database table
- by Andrew Welch
I have a table which contains house details called property. I am creating a localised application, and I have a db table called propertylocalised. In this table is held duplicates of the data and culture column e.g.
key culture propertyname
1 en helloproperty
1 fr bonjourproperty
At the moment I have all my en culture inserted but I want to duplicate all of those rows and then for every other row insert fr into culture.
I obviously only want to do this once, for the purpose of setting up the localisation.
Thanks
Andy