Identity Seed/Increment

Results 1 to 2 of 2

Thread: Identity Seed/Increment

  1. #1
    Join Date
    Dec 1969

    Default Identity Seed/Increment

    Hi:<BR><BR>How do I assign an identity to the following line (item_id) and increment by 1? I work on SQL Server, I want to create a table in my asp page.<BR><BR>SQLstr = SQLstr & "item_id INT NOT NULL PRIMARY KEY,"<BR><BR>Thanks-

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Identity Seed/Increment

    item_id INT NOT NULL PRIMARY KEY identity(1,1)<BR><BR><BR>this has a seed of 1 and an increment or 1

Posting Permissions

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