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

No comments:

Post a Comment