INSERT INTO Name (Field Name 1, Field Name 2, ...) SELECT Field Name 1, Field Name 2, ... from another table name; more useful example is: INSERT INTO table name (PK, field Name 2, ...) SELECT sequence name .NextVal, field 2 value, ... from dual
Implementation in SQL Server: Inserts records that meet the conditions in Old_Table into another table, as follows: select * INTO new_TABLE from Old_Table Where ....
