Sign in
Zen and the Art of SQL Server Maintenance
A blog about SQL Server.
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Tags
SQL Server 2012 Availability Group Configuration
SQL Server Identity
Browse by Tags
MSDN Blogs
>
Zen and the Art of SQL Server Maintenance
>
All Tags
>
sql server identity
Tagged Content List
Blog Post:
Using SELECT INTO to create an on-the-fly IDENTITY Column
Mike Wilmot
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
on
28 Dec 2007
Page 1 of 1 (1 items)