自动增加: 先建一个序列:
CREATE sequence seq_for_insert
start with 12000000
increment by 1
nocache;再建一个trigger:
CREATE or replace trigger Trig_for_insert
before insert on TableName
for each row
BEGIN
select seq_for_insert.nextval into :new.SN from dual;
END;
/
CREATE sequence seq_for_insert
start with 12000000
increment by 1
nocache;再建一个trigger:
CREATE or replace trigger Trig_for_insert
before insert on TableName
for each row
BEGIN
select seq_for_insert.nextval into :new.SN from dual;
END;
/
SQLSERVER的TSQL语法与ORACLE的PLSQL语法相差太多了。不过,思路是相同的!!!