FYI: You can only have one field set to autoincrement per table in SQL Server, which is usually reserved for the primary key.

>>Dear all,
>>
>>Can I use a single SQL statment to update a field in sequence? For example, I created a table which contains 2 fields (one is product id, another is seq #). I would like to update the seq # sequencely. record 1 = 1, record 2 = 2, record 3 = 3 .... In VFP, I can use recno() to do that. How about on SQL Server using SQL passthrough command? Thank you for your help ....
>>
>>Best Regards,
>>
>>Justy Chow
>
>Doesn't SQL Server have an "autoincremented" field type? If you want to use sequential numbers as primary keys, I think this is what you really need.
>
>Hilmar.