CREATE TRIGGER addb ON [dbo].[b] FOR INSERT AS update poorders set ORDER=a.ORDER+1 from inserted b, (select max(ORDER) from deleted group by orderno where orderno=b.orderno) a 这句有点问题!?
这句怎么写呀!我写 CREATE TRIGGER addb ON [dbo].[b] FOR INSERT AS update poorders set ORDER=a.ORDER+1 from inserted b, (select max(ORDER) from deleted group by orderno where orderno=b.orderno) a where b.orderno=a.orderno 还是报错啊!
当pono相同时在最大ORDER上加1
FOR INSERT
AS
update poorders set ORDER=a.ORDER+1 from inserted b,
(select max(ORDER) from deleted group by orderno where orderno=b.orderno) a
这句有点问题!?
CREATE TRIGGER addb ON [dbo].[b]
FOR INSERT
AS
update poorders set ORDER=a.ORDER+1 from inserted b,
(select max(ORDER) from deleted group by orderno where orderno=b.orderno) a
where b.orderno=a.orderno
还是报错啊!