How to insert data into another table

Category: MS-SQL Server -> Applications Author: pk20022671 Date: 2001-07-08 13:57:16
 
pk20022671
2001-07-08 13:57:16
table_1 and table_2 data structures, is the same table in the library, table_2 there are a lot of data, how is inserted into table_1 ...
qq591723861
2001-07-08 14:15:16

insert into table_1 select * from table_2
insert into table_1 select * from table_2 where ...