How to copy a row from one SQL Server table to another

January 2, 2023 by Tarik

As long as there are no identity columns you can just

INSERT INTO TableNew
SELECT * FROM TableOld
WHERE [Conditions]