Thanks, Sergey!
>You can use numeric datatype (int, bigint, numeric, e.t.c) column with IDENTITY property.
>
>>I have often used the autonumber data type in Access and have created stored procedures in the default value to autoincrement in VFP. I need to accomplish the same thing in SQL server, but have little TSQL knowledge and can't find any canned ways to autonumber an inserted record for a primary key.
>>
>>Anybody know the preferred way to accomplish this in SQL server? Any examples would be most helpful.
>>
>>Thanks!
Steve Howie, owner
DaSH Technology
Denver, CO