Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Key definition
Message
De
22/02/2012 09:38:25
 
 
À
22/02/2012 09:32:08
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Divers
Thread ID:
01536063
Message ID:
01536097
Vues:
26
Thanks Dorris

any idea what the first part could be ?

>Then I'd bet that the latter part of that is day(date()) + seconds() * 10000 + '0000'
> Or, some minor variation thereof
>
>>pretty sure its a timestamp. The 231258 line was when I set my clock date to 23rd Feb
>>
>>T1712261622122531240000
>>T1712261622124027560000
>>T1712261622124938660000
>>T1712261622125659720000
>>T1712261623125813170000
>>T1712261622010219640000
>>
>>>It seems to me that the 2212253etc is a little long for a time stamp? Obviously it's right padded with zeroes, but wouldn't a time stamp look more like 221253 (hour,minute,seconds) or 81517894 (seconds() with the decimal removed). I'd have to see a few more record keys in the order they appear to make more sense of it.
>>>
>>>I know - not much help
>>>
>>>>This is a a long shot.
>>>>
>>>>I'm dealing with a package and a table in that package has keys generated like.
>>>>
>>>>T1712261622122531240000
>>>>
>>>>I think that 22122531240000 is some sort of time stamp but I'm not sure about the T17122616. Its the same for all the entries I have put in. Could it be some sort of connection number ? It doesn't alter if I log out of the system and log back in.
>>>>
>>>>I want to be able to generate some data to enter into this table and I'd like to emulate the existing key structure.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform