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

Comments

• Anonymous
  December 30, 2007
  AJAX ASP.NET AJAX Control Toolkit - Basic Sample For DynamicPopulate Control [Via: alikl ] ASP.NET ...

• Anonymous
  December 30, 2007
  Link Listing - December 30, 2007

• Anonymous
  June 05, 2015
  Thanks for the info, worked a charm