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()