sql - Insert into ... Select *, how to ignore identity? - Stack Overflow

I have a temp table with the exact structure of a concrete table T. It was created like this: select top 0 * into #tmp from T After processing and filling in content into #tmp, I want to copy the ... As identity will be generated during insert anyway, cou

stackoverflow.com