Autonumber in SQL Server?

Results 1 to 2 of 2

Thread: Autonumber in SQL Server?

  1. #1
    Join Date
    Dec 1969

    Default Autonumber in SQL Server?

    Can you have an autonumber in sql? If you can&#039t how am i supposed to get a unique field since all the data in this table will have some of the same data in 2 or more rows. This table is to search for loads so any one person can have multiple loads.

  2. #2
    Join Date
    Dec 1969

    Default RE: Autonumber in SQL Server?

    sql server&#039s equivalent is the identity column, when creating the table make the column an &#039identity&#039 type, and choose the seed value (ie., what number you want the autonumbering to start at).<BR><BR>

Posting Permissions

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