SQL APPEND TABLE vs. CREATE TABLE

--TO CREATE A NEW TABLE:

SELECT *
INTO newTableName
FROM sourceTableName



--TO APPEND DATA TO AN EXISTING TABLE:

INSERT INTO existingTableName
SELECT *
FROM sourceTableName