Oracle,创建序列->创建触发器
yss_test_seq ehr
-- Create sequence
create sequence yss_test_seq
minvalue 1
start with 1
increment by 1
order;
create or replace trigger yss_test_trg
before insert on YSS_TEST
for each row
begin
select yss_test_seq.nextval into:New.id from dual;
yss_test_seq ehr
-- Create sequence
create sequence yss_test_seq
minvalue 1
start with 1
increment by 1
order;
create or replace trigger yss_test_trg
before insert on YSS_TEST
for each row
begin
select yss_test_seq.nextval into:New.id from dual;
end yss_test_trg;
SqlServer,把表的主键设为标识
create table