Monday, March 12, 2012

primary key

Hi,

Is it a good practice to keep primary key as auto incremental or not.
Please reply ASAP as I want to design a database.

Thanks
Shubhangiyes as generally you want your primary keys to be unique|||It is a good practice to increment primary key column automatically. If the first row is null or 0 set to 1 else increment by using max(column) + 1
in the insert sp

No comments:

Post a Comment