How Can i make a sequence in sql server 2005 or make auto number on table like id
but i need it as int and auto number like(0,1,2,3,4,5...................)
like oracle sequence
Thanks!!!!!!!
Loading
How Can i make a sequence in sql server 2005 or make auto number on table like id
but i need it as int and auto number like(0,1,2,3,4,5...................)
like oracle sequence
Thanks!!!!!!!
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Niradhip ChakrabortyPosted Apr 21, 2008, 5:10 PM
Right click on table name,Click modify.
It will open the table with column name,datatype and allownulls
Select the column name and. Go to column properties below and inside table designer
select the description field and write the following in description
Id with Identity seed as 1 and identity increment as 1
So u need not to insert value for this column. Every time u insert data in table it will take
auto numbers incremented by 1.