Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jesse McLain Generate INSERT for table with IDENTITY column RE: Generate INSERT for table with IDENTITY column

  • March 7, 2008 at 6:44 am

    #786607

    Won't be easy to exclude identity column from insert statement?

    existing table T1 (ID [int] IDENTITY(1,1) NOT NULL,

    A1 varchar(50),A2 varchar(50),A3 varchar(50)......)

    insert into T1 (A1,A2,A3,...)

    select B1,B2,B3,... from T2