I am just getting started with SQL server and I see that there is no "auto number" data type. What is the equivalent for "auto number" in SQL?<BR><BR>Thanks,<BR><BR>Rob
The equivalent is an identity field. You can specify a field as an identity column when creating a new table.
while ur creating the field ,u'll get the characeter(content) what u should have to give.<BR>example;<BR>cust_code----------> text else varchar else autonumber withlength(12) with any description<BR>