可以用trigger做create trigger insert_record on Material
for insert
as
begin
insert into MatManager(mat_id) select mat_id from inserted
end
for insert
as
begin
insert into MatManager(mat_id) select mat_id from inserted
end
ON 触发器
FOR INSERT
AS
这里为插入MatManager表的语句
for insert
as insert into MatManager(mat_id)
values select mat_id from inserted