Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
High precision date/time stamp in SQL Server 2005
Message
From
15/03/2011 12:10:52
Mike Beane
Round Lake, Illinois, United States
 
 
To
15/03/2011 11:35:30
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Re: High precision date/time stamp in SQL Server 2005
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01503716
Message ID:
01503735
Views:
27
>>>I have bulk records that are getting imported into a SQL Server 2005 table. I need to be able to maintain the same order that they were imported. I was using a DateTime field and populating it to GETDATE(), but that wasn't precise enough.
>>>
>>>Any advice out there?
>>
>>In SQL Server 2005 there is no date types with high precision. There are several in SQL Server 2008 (DateTime2).
>
>Any other ideas? I received a recommendation elsewhere to rely on the autoincrementing identity column, but I've always believed that to be bad practice.

Really? How come?
Previous
Reply
Map
View

Click here to load this message in the networking platform