How to copy a row from one SQL Server table to another

Question

I have two identical tables and need to copy rows from table to another  What is the best way to do that   I need to programmatically copy just a few rows  I don t need to use the bulk copy utility

User · Answer

INSERT INTO DestTable SELECT   FROM SourceTable WHERE        works in SQL Server

User · Answer

Jarrett s answer creates a new table   Scott s answer inserts into an existing table with the same structure   You can also insert into a table with different structure   INSERT Table2  columnX  columnY  SELECT column1  column2 FROM Table1 WHERE  Conditions

User · Answer

SELECT   INTO  lt  new table  gt  FROM  lt  existing table  gt  WHERE  lt  clause  gt

User · Answer

As long as there are no identity columns  you  can just     INSERT INTO TableNew SELECT   FROM TableOld WHERE  Conditions

User · Answer

Alternative syntax   INSERT tbl  Col1  Col2       ColN    SELECT Col1  Col2       ColN   FROM Tbl2   WHERE       The select query can  of course  include expressions  case statements  constants literals  etc

[sql] How to copy a row from one SQL Server table to another

Examples related to sql

Examples related to sql-server