Timestamp as Primary

• babuganesh2000

  Hall of Fame

  Points: 3123

  More actions

  January 5, 2005 at 10:38 am

  #68028

  Though timestamp column is a unique identifier, why it is not prefered to set as primary key by design.

  Any one who can advise me for the appropriate answer.

  Thanks,

  Ganesh

   

• noeld

  SSC Guru

  Points: 96590

  More actions

  January 5, 2005 at 11:03 am

  #536038

  the timestamp column CHANGES if you update any other column in the row!

  HTH

   

  
  * Noel

• babuganesh2000

  Hall of Fame

  Points: 3123

  More actions

  January 5, 2005 at 12:09 pm

  #536051

  tq

• robertk

  SSCommitted

  Points: 1608

  More actions

  January 6, 2005 at 10:41 am

  #536248

  you'd be much better off using a row guid.