Copying Records From One Table to Another Using SQL Queries

Copying records from one table to another within a single database is pretty trivial.
Its just a matter of running a query with the structure shown below

insert into TableA(FieldA, FieldB, FieldC)select FieldA,FieldB, FieldC from TableB

If TableA and TableB reside in different Databases you would have to use a fully qualified Table names.

Came across this one today and I just had to share it. :-)

Tags SQL, SQL Server

Leave a Reply