--简化版。 create trigger trig_TABLE2_insert on table2 for insert as update a set number=case b.px when '0' then c.BH_1+right(year(getdate()),2) when '1' then ltrim(year(getdate()))+c.BH_2 end+ case when right((select number from table2 where id=(select max(id) from table2)),1)='F' then right('0000'+(substring((select number from table2 where id=(select max(id) from table2)),4,4)+1),4) else right('0000'+(right((select number from table2 where id=(select max(id) from table2)),4)+1),4) end+case b.px when '0' then 'F' else ''end from TABLE2 a,inserted b,table1 c where a.id=b.id and a.DWID=c.DWID
create trigger trig_TABLE2_insert on table2
for insert
as
update a set number=case b.px
when '0' then c.BH_1+right(year(getdate()),2) when '1' then ltrim(year(getdate()))+c.BH_2 end+ case
when right((select number from table2 where id=(select max(id) from table2)),1)='F'
then right('0000'+(substring((select number from table2 where id=(select max(id) from table2)),4,4)+1),4)
else right('0000'+(right((select number from table2 where id=(select max(id) from table2)),4)+1),4) end+case b.px when '0' then 'F' else ''end
from TABLE2 a,inserted b,table1 c where a.id=b.id and a.DWID=c.DWID
up,sdhdy觸發器很強悍