--級聯(lián)刪除（不帶外鍵）
create trigger dept_emp_delete
on dept
after delete
as
delete from emp
where deptid in
(select id from deleted)
Go

--限制插入
create trigger dept_emp_insert
on emp
after insert
as
if(select inserted.deptid from dept,inserted where dept.id = inserted.deptid) = 2
begin
? ?print 'the emp is full'
? ?rollback transaction
end
go

insert into emp values ('xiaowang',2,'2700')

轉(zhuǎn)載于:https://www.cnblogs.com/zhangzhu/archive/2012/05/10/2495002.html

總結(jié)

以上是生活随笔為你收集整理的SQL SERVER触发器使用实例的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。