Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sequence/auto incrementing 2

Status
Not open for further replies.
shuklix

shuklix

Programmer
Jul 15, 2003
21
0
0
AU
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
 
Sort by date Sort by votes
sure!
you can use the identity property.

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

definition:
IDENTITY (seed , increment)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

makeitwork09
  • Locked
  • Question
SQL How to create patterned number sequence? 1
Replies
2
Views
21
makeitwork09
makeitwork09
peac3
  • Locked
  • Question
Merge records to get sequence in TIME with condition, Please help...
Replies
2
Views
35
fredericofonseca
fredericofonseca
dinzana
  • Locked
  • Question
Need help with populating a column with a sequence number (I think) 2
Replies
4
Views
26
Olaf Doschke
Olaf Doschke
mwake
  • Locked
  • Question
Create Unique Order # with Order # + Sequence #
Replies
2
Views
34
mwake
mwake
junkmail
  • Locked
  • Question
sequence numbers 1
Replies
5
Views
16
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top