Sequence

Question

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(012345...................) like oracle sequence Thanks!!!!!!!

Niradhip Chakraborty · Answer

Right click on table nameClick modify. It will open the table with column namedatatype 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.