In SQL, sometimes we need to select some data from one table and insert data into another table, this can be done as follows with a simple sql query:
Insert into Table1 (c1, c2, c3, c4, c5)
(Select c1, c2, c3, c4, c5 from Table2)
But make sure that both the tables have same fields, data type..
Tuesday, September 1, 2009
Inserting Data Into Table Using Select Query
at
6:03 PM
·
Labels: Sql Server
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment