CREATE TRIGGER trigger_film_add
ON film_add
FOR INSERT
AS
declare
@fid int,
@fnum varchar(10),
@fadd varchar(100),
@fsize int
select
@fid=film.fid,
@fnum=null,
@fadd=null,
@fsize=null
fromfilm_add
where film_add.fid=film.fid
insert into film_add(film_add.fid,fnum,fadd,fsize)
values(@fid,@fnum,@fadd,@fsize)
---------------------------------------------------
第二个表属性
film_add
(fid int,
fnum varchar(10),
fadd varchar(50),
fzize int
)
----------------------------
如何为第二个表做一个级联插入的触发器？如果第二个表的触发器做好了，第一个表（如图）用做触发器？恳请高手帮忙或留下QQ，谢谢
上面的触发器是错误的！！！！！
|
