1、创建级联删除触发器
USE [xiaoqu]
Go
Create trigger delest
On Cash1
for delete
as
delete from Cash where Id in (select Id from deleted)
delete from YingShou where Id in (select Id from deleted)
1、创建级联删除触发器
USE [xiaoqu]
Go
Create trigger delest
On Cash1
for delete
as
delete from Cash where Id in (select Id from deleted)
delete from YingShou where Id in (select Id from deleted)