sequence curval
From: Hui Li <li_at_openmarket.com>
Date: 1996/04/26
Message-ID: <4lqlfs$n8l_at_brighton.openmarket.com>#1/1
Date: 1996/04/26
Message-ID: <4lqlfs$n8l_at_brighton.openmarket.com>#1/1
Sequence vs. identity
In the Sybase, you can use 'select _at__at_identity'
'select sequence.curval from dual'
(Does this require a transaction?, dual is a system table)
a sequence we can do
Process 1 Process 2 --------- --------- insert record insert record select seq.curval from dual select seq.curval from dual
If the second record is inserted before the first process 'select'. What
curval I will get from procees 1?
Shuzi Chen
chen_at_openmarket.com
Received on Fri Apr 26 1996 - 00:00:00 CEST