Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    139

    Unanswered: uniqueidentifier data type

    I'm using the uniqueidentifier data type to generate a unique key for a table. Is there a way to change the type of unique key that's generated? I'd like it to start at 200,000 and increment as integers by 1.
    Thanks,
    Bill

  2. #2
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    straight from BOL
    Code:
    CREATE TABLE new_employees
    (
     id_num int IDENTITY(200000,1),
     fname varchar (20),
     minit char(1),
     lname varchar(30)
    )
    just change the seed value to whatever value you want to start from...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •