Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Jones The Identity Select RE: The Identity Select
morlindk
SSCrazy
Points: 2294
More actions
January 11, 2019 at 2:11 am
#2018670
Elegant! - Yet, if I only wanted to add an identity column, in order to keep the table name (and save on storage), I would use simplyALTER TABLE dbo.Names ADD id INT IDENTITY(1, 1)