Select Into with Identity()

This video shows you how to use the Identity() function to create an identity column on the fly during a select into statement. You don’t have to settle for Alter Table anymore.