Copy data into another table

by

If both tables are truly the same schema:

INSERT INTO newTable
SELECT * FROM oldTable

Otherwise, you’ll have to specify the column names (the column list for newTable is optional if you are specifying a value for all columns and selecting columns in the same order as newTable‘s schema):

INSERT INTO newTable (col1, col2, col3)
SELECT column1, column2, column3
FROM oldTable

More Related Contents:

  1. Unpivot with column name
  2. How can I delete using INNER JOIN with SQL Server?
  3. Is there a way to access the “previous row” value in a SELECT statement?
  4. What this query does to create comma delimited list SQL Server?
  5. Convert varchar into datetime in SQL Server
  6. sql query to return differences between two tables
  7. Check if a row exists, otherwise insert
  8. T-SQL datetime rounded to nearest minute and nearest hours with using functions
  9. SQL Server : dynamic pivot over 5 columns
  10. How to select the last record of a table in SQL?
  11. Using a Variable in OPENROWSET Query
  12. How to create table using select query in SQL Server?
  13. Check for file exists or not in sql server?
  14. Group DateTime into 5,15,30 and 60 minute intervals
  15. Is there a SELECT … INTO OUTFILE equivalent in SQL Server Management Studio?
  16. SQL SERVER: Get total days between two dates
  17. Store multiple bit values in a single table column
  18. Which SQL query is faster? Filter on Join criteria or Where clause?
  19. SQL Server equivalent to MySQL enum data type?
  20. Using IF ELSE statement based on Count to execute different Insert statements
  21. SQL Server SELECT INTO @variable?
  22. How do I change db schema to dbo
  23. How to subtract 30 days from the current date using SQL Server
  24. How do I find the data directory for a SQL Server instance?
  25. Count records for every month in a year
  26. SQL Server: +(unary) operator on non-numeric Strings
  27. Use one CTE many times
  28. How to Select Every Row Where Column Value is NOT Distinct
  29. How to do a case sensitive GROUP BY?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment