To Generate serial number automatically

[jeenajos]

Hi all,
I need to insert a column in a table as sno but it should generated numbers from 1,2,3,.....It is similar to ms excel's auto number.Tel me a way to do it in SQL Express.

Cheers
Jeen

[iburyak]

Try this:

Alter your_table_name add ID int identity(1,1)

When you issue insert statement omit mentioning this column and number will be generated automatically.

[ck9663]

one catch...

identity columns ensures uniqueness but not "sequential-lity" (if there's even a word)...

[jeenajos]

Thanks to all. I tried ur solution and its working....