create table a (a int,aa varchar(100)) create table b (b int,bb varchar(100)) go create view c as select a.*,b.* from a,b where a.a=b.b go--测试: insert c values(1,'aa',1,'bb') --失败go CREATE TRIGGER 名 on c INSTEAD OF INSERT AS BEGIN INSERT a select a,aa from inserted INSERT b select b,bb from inserted END go--测试: insert c values(1,'aa',1,'bb')
create table b (b int,bb varchar(100))
go
create view c
as
select a.*,b.* from a,b where a.a=b.b
go--测试:
insert c values(1,'aa',1,'bb')
--失败go
CREATE TRIGGER 名 on c
INSTEAD OF INSERT
AS
BEGIN
INSERT a select a,aa from inserted
INSERT b select b,bb from inserted
END
go--测试:
insert c values(1,'aa',1,'bb')