34,588
社区成员
发帖
与我相关
我的任务
分享
CREATE TRIGGER trg_del ON dbo.ta
INSTEAD OF DELETE
AS
BEGIN
DECLARE @cou INT
SELECT @cou = COUNT(1)
FROM deleted;
IF ( @cou > 0 )
RAISERROR ('数据不允许删除!', 16, 1)
END