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

  • December 27, 2012 at 8:53 am

    #1571894

    Thanks Jeff. I was hoping for something which could use "SELECT *", so knowledge about the extant columns wouldn't be necessary. Neat technique, though, if the column names and the column with the IDENTITY attribute are known in advance. I'll add this bit to my "tool box".