如果只是修改触发器体 把create 改成 alter就好了 如 alter trigger 名字 for insert as ....
直接把create改成alter就可以了啊:然后在 你需要修改的地方加上那些内容 alter trigger tr_delete on v_view instead of delete as declare @stuid varchar(15),@stuname varchar(20), @math int select @stuid=stuid,@stuname=stuname,@math=math from deleted delete tbl_score where stuid=@stuid delete tbl_stu where stuid=@stuid
把create 改成
alter就好了
如
alter trigger 名字
for insert
as
....
你需要修改的地方加上那些内容
alter trigger tr_delete on v_view
instead of delete
as
declare @stuid varchar(15),@stuname varchar(20),
@math int
select @stuid=stuid,@stuname=stuname,@math=math
from deleted
delete tbl_score where stuid=@stuid
delete tbl_stu where stuid=@stuid