var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Auto Sequencing using trigger
I have only beginner level knowledge in Oracle and very new to sybase.
I would need to tranlate the below oracle code snippet to Sybase.
Can some one tell me what exactly this piece of code mean and what its equivalent in sybase.
CREATE TRIGGER voip_id
FOR EACH ROW
Declare phoneId number;
select voip_phones_id.nextval into phoneId from dual;
Also found that there is no sequence concept in sybase.How do i go with the sequencing as i suppose the above code if for that only.
Any immediate help on this is highly appreciated.
The equivalent on Sybase would be to use an identity column:
create table test1
(id int identity(1, 1) not null
Auto Sequencing using trigger
In addition you can use identity_gap of your choice while creating the table. This will be the gap between last number assigned and the next number assigned when server restarts.
Tags for this Thread