How to insert identity column into the destination table.

INDNTITY(data_type,[seed,increment]) AS column_name

This will insert an identity column into the destination table when used with SELECT INTO.
Example:-

SELECT IDENTITY(int,1,1) AS IDINTO NewTable FROM ExistingTable