Date as a part of primary key
Hi All,
I want to know are there any benefits to use date as a part of my primary key?
For example in a transaction tables I have many columns and transaction date is one of them and primary key as
This first 8 letters are date in yyyymmdd format and later on some sequence.
20030324001
20030324002
20030324003
20030324004
20030325001
20030325002
.
.
.
Few database designers want this kind of design for there table's primary key. If someone of you ever designed your database tables like this please let me know the precise benefits of this kind of design.
An elephant is a mouse with an operating system.
