CREATE TRIGGER [U_AddOrderFlow] ON [dbo].[订单库]
for INSERT
AS
begin
insert into [订单状态] ([订单号],[添加时间],[添加人]) select [订单号],getdate(),[记录人] from inserted
for INSERT
AS
begin
insert into [订单状态] ([订单号],[添加时间],[添加人]) select [订单号],getdate(),[记录人] from inserted
for INSERT
ASinsert into [订单状态] ([订单号],[添加时间],[添加人]) select [订单号],getdate(),[记录人] from inserted
instead of INSERT
AS
begin
insert into [订单库] select * from inserted
insert into [订单状态]([订单号],[添加时间],[添加人]) select [订单号],getdate(),[记录人] from inserted
end