Copying Records From One Table to Another Using SQL Queries
Thursday, June 5th, 2008Copying 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 […]
