twin.devil (7/7/2014)
Jeff, Actually OP is using (*) when in the select statement something like thisSelect IDENTITY(INT,1,1) AS RowID, *
into SomeTable
From Table
When we use this as the rule of thumb, identity column will be inherit, So only one identity column per table rule violates.
I would suggested OP to use Actual Column Name List and could skipped the identity column, but as he need the 'Actual values', i think ROW_NUMBER() Function will do.
That's precisely why I didn't use SELECT *.:-)
--Jeff Moden
Change is inevitable... Change for the better is not.