Autonumbers in SQL ??

[soulcode]

Hi guys,

are there such things as autonumber datatypes in SQL??

I have the following code that create a table from code, but i want the first column to be an autonumber that SQL server can take care of.

            sqlTableConnection = New SqlConnection(strConnectionStr)
            sqlTableConnection.Open()

            'create table code
            sqlTableComm = New SqlCommand("CREATE TABLE Contects (Title VARCHAR(6) NOT NULL, Firstname VARCHAR(20) NOT NULL, Lastname VARCHAR(20) NOT NULL, Created DATETIME NOT NULL, Deleted BIT NOT NULL)", sqlTableConnection)
            sqlTableComm.ExecuteNonQuery()
            sqlTableConnection.Close()

if there isnt a way to create autonumbers, is it best just to increment a number from the last record in the table??

cheers,

[soulcode]

Also...

What is the best datatype to store phone numbers in?? is it best to store them in a String then validate it on the form, or store it in a number type??


cheers again,

[salvelinus]

Not sure the exact syntax for SQL Server, but there should be a setting for autoincrement. Check the docs.
Store phone numbers as text. You won't ever perform calculations on them, and if you store them with (), -, etc, that's text anyway.

[ARPRINCE]

Try....

CREATE TABLE Connects (
    ConnectsID int IDENTITY (1, 1) NOT NULL , Title VARCHAR(6) NOT NULL, .....

[Memnoch1207]

Or use a UniqueIdentifier instead of an Identity.
I would store phone numbers in a varchar(14) field.

[BlackDeath78]

Hi folks,

ARPRINCE has posted the correct syntax for an int column with an automatic generated number.

If you prefer a GUID for your PKs try this:

CREATE TABLE Connects (MyKey uniqueidentifier NOT NULL DEFAULT newid())

Bye
BD