Thursday, February 28, 2008

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

No comments: