July 24, 2003 03:24 PM

Using Datetime Columns as Primary Keys

Rating: (0)
SQL Server Magazine
InstantDoc ID #39448

I'm using a datetime column in SQL Server 2000 as a unique key, and I'm trying to query the data using a Microsoft Access form. I can query the data, but when I try to create two new rows that have primary keys, such as 2003-04-17 00:00:00:00 and 2003-04-17 00:00:00:01, I get an error message indicating that I've entered a duplicate key. What's the problem?

...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

Good tip, besides this topic has been mentioned in other articles. Looks like the magazine keeps comming back to the same subject from time to time. Is this due a lack of subject?

Regards.

Marcos3/18/2009 10:42:34 AM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS