if you have say table `Contacts` in database1 and you want to copy `ContactID=123` to database2. Copying all columns (except `ID` I guess) assuming Contacts table exists in both databases and identical schema. Also both databases are in same server.

the long way is to list each column in the insert statement, but is there a way without listing all columns? or at least automatically get all columns.

I am looking at SQL Server 2012

I tried: 

```
SELECT * into [database2].[dbo].[Contacts] from [database1].[dbo].[Contacts] where [ContactsID]=123

```

but got error: 

> 
> There is already an object named 'Contacts' in the database.
> 
> 
>