26/07/2005, 08:22
| |||
| |||
| GUIDs en SQL Server Hola colegas... Necesito saber si alguien a tenido la amarga experiencia de hacer lo siguiente... Necesito retornar el ultimo ID que se genero en una transacción en SQL Server, pero resulta que este id es un GUID… ya he probado con @@Identity y SCOPE_Identity y nada de esto soporta GUID, alguien ha hecho esto...?? Gracias |
|
26/07/2005, 14:47
| ||||
| ||||
| Encontré esto en los Books Online: Cita: Lo encuentras bajo el título "Using uniqueidentifier Data" The uniqueidentifier data type has several disadvantages: The values are long and obscure. This makes them difficult for users to type correctly, and more difficult for users to remember. The values are random and cannot accept any patterns that may make them more meaningful to users. There is no way to determine the sequence in which uniqueidentifier values were generated. They are not suited for existing applications that depend on incrementing key values serially. At 16 bytes, the uniqueidentifier data type is relatively large compared to other data types such as 4-byte integers. This means indexes built using uniqueidentifier keys may be relatively slower than implementing the indexes using an int key.
__________________ Friedrich Nietzsche |
