Oracle Or SQL SErveranyway , it's not so difficult .create table seq_ta ( seq number)
insert into seq_ta values ( 0)create a trigger on mytable , while insert
select seq into variable from seq_ta
:new.autoid = variable + 1
update seq_ta set seq = seq + 1
总之,用trigger很容易完成
insert into seq_ta values ( 0)create a trigger on mytable , while insert
select seq into variable from seq_ta
:new.autoid = variable + 1
update seq_ta set seq = seq + 1
总之,用trigger很容易完成
解决方案 »
- execl 2007 的数据怎么导到sqlserver2005 啊???/
- 请问这句话什么意思?
- 用isql备份数据库请教
- 关于dts导入数据的问题,急盼高手解答!
- 求助access 转SQL后遇到的问题2,明明有表,竟然找不到表?
- 将数据库中某个长字段分成几个字段
- ALTER TABLE DoorParam ADD Default8 BIT DEFAULT 1有点不明白?
- 关于数据库设计的问题!
- ▂▃▅▆█▓ 香港 大连 上海 ▂▃▅▆█▓ 三地数据库同步
- OracleStartXXXX启动不起来,怎幺办?
- 哪有中文版 比较系统的SQL SERVER 2000的书下?
- 急救,请各位高手帮助,分不够可加。
触发器的while是如何实现的?
LOOP
<executable statement(s)>
END LOOP;
第一步:创建SEQUENCE
create sequence s_country_id increment by 1 start with 1 maxvalue 999999999;
第二步:创建一个基于该表的before insert 触发器,在触发器中使用该SEQUENCE
create or replace trigger bef_ins_t_country_define
before insert on t_country_define
referencing old as old new as new for each row
begin
new.country_id=s_country_id.nextval;
end;
--
CREATE SEQUENCE USERID INCREMENT BY 1 START WITH 1
MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE
NOCACHE NOORDER2.创建触发器USERADD 会员触发器
--
CREATE OR REPLACE TRIGGER USERADD
BEFORE INSERT ON MEMBERRG
FOR EACH ROW
BEGIN
USERID.NEXTVAL INTO :NEW.NUM FROM DUAL;
END;
before insert on t_name ln number for each row;
begin
select max(id) into ln from t_name;
new.id=ln+1;
end;
select itemid from mytable这个在 SQL Server 里 Trigger 也不能实现!