34,593
社区成员
发帖
与我相关
我的任务
分享
--用触发器吧
CREATE TRIGGER [TRIGGER_person] ON [dbo].[person]
FOR INSERT, UPDATE, DELETE
AS
begin
if (select top 1 count(a.id) from person a,inserted b
where a.status=0 and b.status=0 and a.id=b.id
group by a.id order by count(a.id) desc)>1
rollback
end