Duplicating records in a table with a SQL query
How can I duplicate every record in a table with a query in SQL?
Software/Hardware used:
Software/Hardware used:
ASKED:
January 14, 2009 4:54 PM
UPDATED:
January 14, 2009 7:01 PM
Answer Wiki:
You could do it this way:
<pre>INSERT INTO YourTable
SELECT *
FROM YourTable
GO</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
