Insert all values of a table into another table in SQL

by

The insert statement actually has a syntax for doing just that. It’s a lot easier if you specify the column names rather than selecting “*” though:

INSERT INTO new_table (Foo, Bar, Fizz, Buzz)
SELECT Foo, Bar, Fizz, Buzz
FROM initial_table
-- optionally WHERE ...

I’d better clarify this because for some reason this post is getting a few down-votes.

The INSERT INTO … SELECT FROM syntax is for when the table you’re inserting into (“new_table” in my example above) already exists. As others have said, the SELECT … INTO syntax is for when you want to create the new table as part of the command.

You didn’t specify whether the new table needs to be created as part of the command, so INSERT INTO … SELECT FROM should be fine if your destination table already exists.

More Related Contents:

  1. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  2. Insert results of a stored procedure into a temporary table
  3. How can I do an UPDATE statement with JOIN in SQL Server?
  4. Select top 10 records for each category
  5. The multi-part identifier could not be bound
  6. How important is the order of columns in indexes?
  7. Using the result of an expression (e.g. Function call) in a stored procedure parameter list?
  8. sql query to return differences between two tables
  9. SQL Server – transactions roll back on error?
  10. Difference between a User and a Login in SQL Server
  11. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  12. Fastest way to update 120 Million records
  13. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  14. Insert Picture into SQL Server 2005 Image Field using only SQL
  15. Execute Stored Procedure from a Function
  16. How do I group on continuous ranges
  17. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  18. Restrict an SQL Server connection to a specific IP address
  19. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  20. SQL server identity column values start at 0 instead of 1
  21. How do you copy a record in a SQL table but swap out the unique id of the new row?
  22. How to compare dates in SQL Server
  23. How do I expand comma separated values into separate rows using SQL Server 2005?
  24. Cumulative Total in MS Sql server [duplicate]
  25. Use variable with TOP in select statement in SQL Server without making it dynamic [duplicate]
  26. SQL query to group by day
  27. Export table data from one SQL Server to another
  28. How do I find the data directory for a SQL Server instance?
  29. Compare dates in T-SQL, ignoring the time part
  30. SQL, How to Concatenate results?

Leave a Comment