Add Identity Column to Table created by SELECT INTO

July 13, 2007 by Emad Gabriel

An Easy way to add an Identity column to a table created by SELECT .. INTO is:

Assume the table is created using

SELECT NAME INTO NAMES2 FROM NAMES1

simply add this,

SELECT IDENTITY(INT, 1,1) AS [ID], NAME INTO NAMES2 FROM NAMES1

Posted in Uncategorized | Leave a Comment

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s

%d bloggers like this:

Emad's Blog