Thread Status:

Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

1. 

   j-w-thomas

   Using SQL Express is there a setting when creating a table in MS SQL Server 2005 so that one field is auto incrementing with each new entry?
   This would become the unique ID number as normal
   
   In MS Access it is: AutoNumber
   
   Also should it be set to field type bigint or something like that?
   
   Thanks,
   
   John

    

   j-w-thomas, May 9, 2007

   #1
2. 

   Bruce DiscountASP.NET Staff

   There is no AutoNumber data type for MS SQL.
   
   
   You can set the id colume to Int and set it to be identity.
   
   
   Bruce
   
   DiscountASP.NET
   www.DiscountASP.NET

    

   Bruce, May 9, 2007

   #2

Thread Status:

Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

• Log in with Facebook
• Log in with Twitter

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in