title: T-SQL Insert into table without having to specify every column
body: <p>In our db there is a table that has a little over 80 columns. It has a primary key and Identity insert is turned on. I'm looking for a way to insert into this table every column <strong>EXCEPT</strong> the primary key column from an identical table in a different DB.</p>
  
  <p>Is this possible?</p>