Sequence Number in SQL Server2000

[kiranpchandran]

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

[cjlindstrom]

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