Home Forums SQL Server 2008 T-SQL (SS2K8) SELECT * INTO Table without propagating IDENTITY attribute? RE: SELECT * INTO Table without propagating IDENTITY attribute?

  • Thank you, Scott! With the addition of a WHERE clause on the first SELECT, I end up with an empty table without a IDENTITY property, which is EXACTLY what I was looking for. Prefacing the * with my additional control columns doesn't mess up the solution, either. SSC rules!