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

  • I want a clone of the table (with 3 addition, preceeding, columns), with the original column sequence, if possible. I'd rather not have to resort to dynamic SQL to define the table, but the presence of the IDENTITY attribute is a "deal killer", since the purpose is short-term "before / after" storage for content changes.