Query to Transfer Data?
-
I have two identical tables in which the columns and data types are of same type. But one table is having some data whereas the other table is empty. Both are existing tables. I want to transfer/copy all the data from table1 to table2 by using a query. How can I do this with a query Thanks, Sandeep S. Sekhon
-
I have two identical tables in which the columns and data types are of same type. But one table is having some data whereas the other table is empty. Both are existing tables. I want to transfer/copy all the data from table1 to table2 by using a query. How can I do this with a query Thanks, Sandeep S. Sekhon
INSERT INTO Table2
SELECT * FROM Table1
Scottish Developers events: * .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog