SQLServer里有TEST,TEST2两个表，要创建一个触发器，删除TEST表的同时删除TEST2中相同的数据，请问怎么写
2个回答
展开全部
create trigger tri_test_delete
on test for delete
as
begin
delete test2 from test2 t1,deleted t2 where t1.key=t2.key ------key 为test,test2的主键。
end;
on test for delete
as
begin
delete test2 from test2 t1,deleted t2 where t1.key=t2.key ------key 为test,test2的主键。
end;
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
