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
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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