Compartir a través de

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

  • Artículo

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