Sql insert data from one table to another

Question

i have a doubt. i need the syntax for SQL SERVER – how to Insert Data From One Table to Another Table?

Accepted Answer

use `INSERT INTO..SELECT` statement

```
INSERT INTO table2 (col1,...)
SELECT col1,...
FROM table1
```

- SQLFiddle Demo (different records but have same thought)

Solution