Zen and the Art of SQL Server Maintenance : Using SELECT INTO to create an on-the-fly IDENTITY Column

Recent Posts

Tags

SQL Server Identity

Archives

Using SELECT INTO to create an on-the-fly IDENTITY Column

Here is a nifty way to add an IDENTITY column on the fly...

select distinct

id=IDENTITY (int, 1,1),

usr

into dim_usr

from fact_eyeballs

Posted: Friday, December 28, 2007 9:54 PM by mwilmot

Filed under: SQL Server Identity

Comments

Christopher Steen said:

AJAX ASP.NET AJAX Control Toolkit - Basic Sample For DynamicPopulate Control [Via: alikl ] ASP.NET ...

# December 31, 2007 1:21 AM

Christopher Steen said:

Link Listing - December 30, 2007

# December 31, 2007 1:22 AM

Anonymous comments are disabled