CODEWITHSUNDEEP
sqlsql-server-2000
Sagar
Sagar

Reputation: 1

auto incrementing id in sql server

How to auto increment an id in SQL Server whenever a new row is inserted in the table? This id is primary key of the table.

Upvotes: 0

Views: 3593

Answers (2)

HLGEM
HLGEM

Reputation: 96640

And to return the id in your code lookup scope_identity() and the OUTPUT clause. De not use @@identity as it can return the wrong value if triggers are put on the table, therefore it is not safe to use if you value data integrity.

Upvotes: 0

AdaTheDev
AdaTheDev

Reputation: 147344

You're looking for IDENTITY.

e.g.

CREATE TABLE MyTable
(
ID INTEGER IDENTITY(1,1) PRIMARY KEY,
FieldA VARCHAR(10)
)

The ID field will auto increment, starting at 1 and increasing by one each time.

Upvotes: 4

Related Questions