<p>I have two identical tables and need to copy rows from table to another. What is the best way to do that? (I need to programmatically copy just a few rows, I don't need to use the bulk copy utility).</p>

```
```
SELECT * INTO < new_table > FROM < existing_table > WHERE < clause >
```
```