Table Design

  • Thread starter Thread starter Squik27
  • Start date Start date
S

Squik27

I want to make Date/Time part of my primary key. I know that date/time is
just a number/counter that started about 30 years ago. what are the chances
of trying to input the same date time when i insert records using sql
statements. I know it's impossible for the user to do it, but how about the
machine, is it fast enough?

thank you.
 
Thank you very much for your answers. They made up my mind. I will introduce
an auto number.
I want to use the date/time stamp to keep track of the movements of an
inventory. One of the keys is the product that is moving but then none of the
other fields allows me to identify each record as unique and since date/time
field have precision i thought i could use it, but you are right the value
depends on how fast the computer is an i could get two product moving at the
same time.

Thank you
 
Back
Top