John's Technical Blog
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment