I appreciate it is utterly trivial question, and yet... When you have a small amount of columns, there is a simple solution, sort of
INSERT INTO myTable
SELECT MAX(table_id) + 1, column2, column3
WHERE table_id IN (SELECT list of table id's to be replicated);
alas I have circa 200 columns, so I don't want to spend time writing them all down. Instead I INSERT INTO temp table and update the ID there. In Oracle you could define %ROWTYPE variable and simply update table_id column, but nothing of this sort exists in SQL 2014, as far as I know at least.
I wonder if there is a good practice in place on how to copy records?
At the bottom line, what I need to achieve is to replicate existing accounts and some other account related tables, assigning them new account id.
Much appreciated, as always.