Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2003 Server
PMFJI, in the database that I use (sybase Sql Anywhere) @@identity is only visible to the connection that did the insert. Is MS Sql different than that?
>>Hi everybody,
>>
>>We're using SPT and then a special program to make cursor updatable. I see this code to get the last inserted value
>>
>> mysqlexec("select @@identity as keyval",'csrKeyVal', program())
>>
>>which doesn't look entirely correct to me - who guarantees that by doing a separate query you'll get the value of the record you just inserted and not someone else in between?
>>
>>Is there a better way to get the latest value?
>>
>>Thanks in advance.
>
>Of course it is not correct. You cannot even guarantee it doing in the same query batch. There are other and reliable ways like:
>
>select scope_identitity()
>
>select ... from inserted
>
>output clause
>
>Cetin
Précédent
Suivant
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