1.Is there any before insert trigger supported for Sybase.
2.How to write the trigger and sequence go hand in hand just like in oracle.
3.Any idea on translating the following piece of oracle code to Sybase.sample_phones_id is a Oracle sequence here.
CREATE TRIGGER sample_id
FOR EACH ROW
Declare rollNum number;
select sample_phones_id.nextval into rollNum from dual;