34,594
社区成员
发帖
与我相关
我的任务
分享
--你可以直接在表上建触发器!当有插入,更新,删除时操作!
create trigger tr_name on tb
for insert,update,delete
CREATE TRIGGER trigger_name ON { table | view }
CREATE TRIGGER 名 on 视图
INSTEAD OF INSERT
AS
BEGIN
INSERT INTO 表1
SELECT name1,name2
FROM inserted
INSERT INTO 表2
SELECT name3,name4
FROM inserted
END
create view viewname
as
select * from tablename