各位好!
我想在一個table 中建立一個 trigger, 來填入流水號 1,2,3...欄位,
請問下列寫法是否有誤?
CREATE TRIGGER TRIGGER_TABLE_A ON TABLE_A
FOR INSERT
AS
update TABLE_A set AUTO_ID=(select max(AUTO_ID) from TABLE_A) 1
from Inserted I
left join TABLE_A A on I.F1=A.F1 and I.F2=A.F2
go

謝謝!!!

------
Romi

try try!
CREATE TRIGGER TRIG_A ON [TABLE_A]
FOR INSERT
AS
UPDATE x SET AUTO_ID=(SELECT MAX(AUTO_ID) 1 FROM TABLE_A)
FROM TABLE_A x
JION Inserted I ON I.F1=x.F1 and I.F2=x.F2
GO

------
What do we live for if not to make life less difficult for each other?

如果table_a 中有一欄col1唯一
CREATE TRIGGER TRIGGER_TABLE_A ON TABLE_A
FOR INSERT
AS
update TABLE_A set AUTO_ID=(select max(AUTO_ID) from TABLE_A) 1
where col1=(select col1 from inserted)

go

------
x