Sequence Number in SQL Server2000

Hi,

I would like to know the best method for creating sequence number. I am using SQL Server2000 as back-end and VB6 as fornt-end.

Thanks in advance
Kiran

Aum Namah Shivaya

When defining your column in SQL set the identity property. This will cause the database engine to increment that field for each new record created. Sort of like a MSAccess Autonumber field.

Craig