Auto-number - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Auto-number

swift_speedswift_speed Posts: 11Member
Does the Microsoft SQL server 2000 got data types auto-number like microsoft access?

Comments

  • DroopyADroopyA Posts: 175Member
    Sure does, but it's not called an "Auto-Number" any more. Make the Field type a long, int whatever, and set the Identity to yes. Then set the Identity seed to 1 as well as the Identity Incrament = 1. That should do it.

    Peace
    -N473

    [hr]
    : Does the Microsoft SQL server 2000 got data types auto-number like microsoft access?
    :

  • swift_speedswift_speed Posts: 11Member
    Thankz for ur help man

Sign In or Register to comment.