Shortest code for generating serial ID.

Question

Assume that you have table (Emp) which consists of (id, name).
What is the best code to generate (ID) starting from (1) to insert it for a new record?

Answer 1

You can achieve such effect by setting auto-increment option for "id" (MySQL) or Identity option (MsSQL). With this option enabled system will automatically assign new id every time a new record is created.

I hope I understand your question correctly here.

Hth, cmiiw

Answer 2

You're very welcome my friend, glad to help ; )

Answer 3

Thanks a lot dear.. great job