Autonumber in Sql-Server.?

Results 1 to 3 of 3

Thread: Autonumber in Sql-Server.?

  1. #1
    Join Date
    Dec 1969

    Default Autonumber in Sql-Server.?

    Hello guys,<BR><BR>what if i want to make any number autonumber in sql server-2000.? I tried this query in ms-access and it is running.<BR>create table tablename (id counter,name text)<BR>but it gives error in ms-sql server 2000. so with what i should replace with counter in sql server .? i using counter in ms-access and it is running so what i should use in ms-sql server.?<BR><BR>Thanks in advance<BR>Umesh

  2. #2
    Join Date
    Dec 1969

    Default Trigger Happy?<eom>


  3. #3
    Join Date
    Dec 1969

    Default Set Field to ID Field, it wil auto increment

    Or if you are using a SQL command to create the table the data type is "Counter"

Posting Permissions

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