John's Technical Blog
Showing posts with label
SQL: Generating Unique Identifier Keys
.
Show all posts
Showing posts with label
SQL: Generating Unique Identifier Keys
.
Show all posts
Monday, 10 August 2009
SQL: Generating Unique Identifier Keys
Create Unique Identifier column and add newid (NEWID()):
UPDATE [dbo].[DimManagement]
    SET [ManagementUniqueKey] =
NEWID()
    ,[CartesisUniqueKey] =
NEWID()
Older Posts
Home
Subscribe to:
Posts (Atom)