help regarding auto increment
Posted: Sun Aug 23, 2009 8:20 pm
I have a table employee where EmployeeID field is set as primary key. How can I create a custom auto increment for my EmployeeID for example:
EmployeeID
SDD00001
SDD00002
SDD00003
Thus when new records are inserted it will automatically increment just like in the example.
Any idea on how can this be done. Thanks
EmployeeID
SDD00001
SDD00002
SDD00003
Thus when new records are inserted it will automatically increment just like in the example.
Any idea on how can this be done. Thanks