Question

在orders表中创建触发器tr_detail,实现在订单表中添加一条记录号为“2007080808”的记录时在ordersdetails

在orders表中创建触发器tr_detail,实现在订单表中添加一条记录号为“2007080808”的记录时在ordersdetails表中添加如下两条记录。
("2007080808","030003",2520,1)
("2007080808","010008",2700,2)

Answer 1

CREATE TRIGGER tr_detail ON orders
WITH EXECUTE AS CALLER
AFTER INSERT
AS
BEGIN
declare @id varchar(50);
select @id=Inserted.[记录号];
insert into ordersdetails([记录号],[字段名1],[字段名2],[字段名3]) values (@id,'030003',2520,1);
insert into ordersdetails([记录号],[字段名1],[字段名2],[字段名3]) values (@id,'010008',2700,2);
END