sqlserver 触发器实现对a表操作时操作其他表

CREATE TABLE tab1(
tab1_id varchar(11)
);
CREATE TABLE tab2(
tab2_id varchar(11)
);

CREATE TRIGGER insertname
ON tab1
AFTER INSERT
AS BEGIN INSERT INTO
tab2(tab2_id)
SELECT tab1_id
FROM INSERTED
END

INSERT INTO tab1(tab1_id) values('0001');