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()
Posted by John at 08:40 No comments:
Labels: SQL: Generating Unique Identifier Keys
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2011 (4)
    • ►  June (3)
    • ►  April (1)
  • ►  2010 (31)
    • ►  November (6)
    • ►  October (10)
    • ►  September (7)
    • ►  May (3)
    • ►  March (3)
    • ►  February (1)
    • ►  January (1)
  • ▼  2009 (45)
    • ►  December (2)
    • ►  November (4)
    • ►  October (10)
    • ►  September (6)
    • ▼  August (1)
      • SQL: Generating Unique Identifier Keys
    • ►  July (2)
    • ►  June (16)
    • ►  February (4)

My Homepage

  • My Homepage

Search This Blog

Awesome Inc. theme. Theme images by epicurean. Powered by Blogger.