学写触发器,看看下面的是否能实现(50分)

U

ugvanxk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-22

• #1

有这样一个表,其中有个内部序号order
我想再插入一条记录时,找出max(order)+1,然后给刚插入的记录赋值上去
怎样编写自增的编号那种触发器,可以吗

 

B

bes96261

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-22

• #2

可以做到

 

B

bes96261

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-22

• #3

Create Trigger Trigger_Name
for Insert

Update table set Order=(select Max(Order)+1 from table)
where Order is Null

 

王

王公子

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-22

• #4

agree upstairs

 

C

chunfly

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-22

• #5

create or replace trigger Trig_name
before insert on
for each row
declare
iOrderId NUMBER(4);
begin
SELECT max(OrderID)+1 INTO iOrderId FROM ORDER ;
INSERT INTO ORDERnew.OrderID) valuse(iOrderid);
end Trig_name;

 

C

cdpclj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-22

• #6

no problem

 

U

ugvanxk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-22

• #7

我得是分类的,原来还设了个order不允许为空,可能是这个捣的鬼
下午试好了就给分

 

B

bes96261

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-22

• #8

Create Trigger Trigger_Name
for Insert

Update table set Order=(select Max(a.Order)+1 from table a,inserted i where a.Type=i.Type)
where Order is Null
--Type類別
這是單條插入的寫法，如果有多條，需另用算法

 

U

ugvanxk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-22

• #9

多人接受答案了。