Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Location
    Pensylvania - USA
    Posts
    15

    Unanswered: Auto Number Data Type?

    Is there a data type like Access's auto number that will automatically assign a record a number? I transfered a database from Access 2000 to SQL 2000 and it did not preserve the autonumber datatype.
    "Me only have one ambition, y'know. I only have one thing I really like to see happen. I like to see mankind live together - black, white, Chinese, everyone - that's all."
    - Bob Marley

  2. #2
    Join Date
    Jan 2003
    Location
    Midwest
    Posts
    138
    Identity is the SQL Server equivalent to the Access autonumber.

  3. #3
    Join Date
    Jul 2003
    Location
    Pensylvania - USA
    Posts
    15
    When I open a table in design view and I change a datatype I do not see Identity in the list.
    "Me only have one ambition, y'know. I only have one thing I really like to see happen. I like to see mankind live together - black, white, Chinese, everyone - that's all."
    - Bob Marley

  4. #4
    Join Date
    Feb 2003
    Location
    Montreal, Canada
    Posts
    117
    Identity is property not a data type.
    Chose a INT type for instance, then (in the bottom of the design screen - columns panel) specify if that's an identity column, the seed and increment eventually.

    Originally posted by aaronshover
    When I open a table in design view and I change a datatype I do not see Identity in the list.
    Steve

  5. #5
    Join Date
    Jul 2003
    Location
    Pensylvania - USA
    Posts
    15
    Thanks, that helped. I got it working now.
    "Me only have one ambition, y'know. I only have one thing I really like to see happen. I like to see mankind live together - black, white, Chinese, everyone - that's all."
    - Bob Marley

Posting Permissions

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