How to create id field in SQL Server?

Question

I want to create a field that will be automatically populated and remain unique.

More explanation: I have an identifier field that should be filled in by my program, not by the user, and is my main key.

How can I do this in SQL Server?

I am using Visual Studio 2010

Answer 1

In the ID column, set "identity" to yes and set "seed" to 1.

Enjoy it!

Answer 2

Use the id column .

create table MyTable (
    ID int identity(1,1) primary key,
...
)

Answer 3

When creating a table, just set it as an identifier and this will give you the value of auto increment id. An example is below.

CREATE TABLE MyTable
(
    MyId INT IDENTITY(1,1) PRIMARY KEY,
    MyColumn VARCHAR(500)
)

IDENTITY(1,1) sets the ID field to start at 1 and increments by one for each new record.

Answer 4

Create an int field and set its Identity property to Yes or

CREATE TABLE [dbo].[Table_1](
[aaaa] [int] IDENTITY(1,1) NOT NULL
   ) ON [PRIMARY]

Answer 5

Take a look at http://msdn.microsoft.com/en-us/library/aa933196(SQL.80).aspx (Identity fields)