No Answer on Database Forum

Results 1 to 4 of 4

Thread: No Answer on Database Forum

  1. #1
    Rainier Guest

    Default No Answer on Database Forum

    Heya guys<BR>I posted a database related question on the database forum but no-one is answering. So I ask the question here..<BR>It&#039;s a kinda simple question but I&#039;m new to SQL server and my database administrator just got fired...<BR>How do you create an automaticly genererated number in a column. What kind of datatype must I use (Numeric? nvarchar?)<BR>Well, that&#039;s the question. regards, rainier

  2. #2
    Join Date
    Dec 1969

    Default RE: No Answer on Database Forum

    Use Int Identity field, Set it to Increment 1 under advanced Features. You might also want to set it as your primary key.

  3. #3
    Join Date
    Dec 1969

    Default Similar Problem!

    I have a Sql table with an Incremented field.... at the mo the table is full of test data. When i delete this test data in order to put the DB live, the DB seems to remember the previous entries and continues at the next increment.... i need to reset this to 1!!!<BR><BR>Any ideas How!?

  4. #4
    J Guest

    Default RE: Similar Problem!

    i think you have to drop & then recreate the table to start the IDENTITY seed back at 1 - sorry...

Posting Permissions

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