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.

---

You're looking for IDENTITY.

eg

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.

---

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.

链接地址: http://www.djcxy.com/p/17136.html

上一篇: 从SQL Server 2000迁移到SQL Server 2008时的问题

下一篇: 在sql server中自动增加id