This guide can be used to insert data into database using select query. Using above syntax, all data in second_table will be copied into first_table. You can also add where keyword. Keywords:sql server 2005