sequence/auto incrementing 2

[shuklix]

Hi Is there an equivalent to sequence(in oracle) in Sql Server ?

I need to have a auto incrementing sequence of numbers which would be used as a primary key for the table.

Saurabh

 

[tomMuc]

sure!
you can use the identity property.

CREATE TABLE test
(
id_key int IDENTITY(1,1) PRIMARY KEY
)

definition:
IDENTITY (seed , increment)