Move SQL data from one table to another

by

Should be possible using two statements within one transaction, an insert and a delete:

BEGIN TRANSACTION;
INSERT INTO Table2 (<columns>)
SELECT <columns>
FROM Table1
WHERE <condition>;

DELETE FROM Table1
WHERE <condition>;

COMMIT;

This is the simplest form. If you have to worry about new matching records being inserted into table1 between the two statements, you can add an and exists <in table2>.

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Get top 1 row of each group
  3. How to cast the DateTime to Time
  4. Row Offset in SQL Server
  5. SQL Server recursive self join
  6. Why is SQL Server losing a millisecond?
  7. Generate a resultset of incrementing dates in TSQL
  8. Find a string by searching all tables in SQL Server
  9. Real life example, when to use OUTER / CROSS APPLY in SQL
  10. How to get script of SQL Server data? [duplicate]
  11. Common Table Expression, why semicolon?
  12. T-SQL split string based on delimiter
  13. Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
  14. How do I find duplicates across multiple columns?
  15. Add unique constraint to combination of two columns
  16. What does a transaction around a single statement do?
  17. SQL Server UNION – What is the default ORDER BY Behaviour
  18. How to get last 7 days data from current datetime to last 7 days in sql server
  19. Stored procedure that exports data into csv files only exports to one file
  20. Get Start and End Date from Week Number SQL Server
  21. Get the last day of the month in SQL
  22. INSERT VALUES WHERE NOT EXISTS
  23. Nested select statement in SQL Server
  24. Inner Joining three tables
  25. SQL take just the numeric values from a varchar
  26. Should I use the CASCADE DELETE rule? [duplicate]
  27. Dynamic order direction
  28. Why is RAND() not producing random numbers?
  29. SQL, How to Concatenate results?
  30. Should every SQL Server foreign key have a matching index? [closed]

Leave a Comment