Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Versions des environnements
SQL Server:
SQL Server 2005
>>>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?
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement