我有一个表,其中有一行数据,我不希望任何人删除它。表名称为ProjectInProcessData。我想确保ID为6050的数据不能被删除。我该怎么做呢?
发布于 2019-02-02 01:50:08
Create Trigger [dbo].[triggerPreventDeleteFormula]
ON [dbo].[AHSC_Project_InprocessData]
INSTEAD OF DELETE
AS
BEGIN
IF EXISTS(
SELECT *
FROM deleted d
where d.AHSC_Project_InprocessData_ID = '6610' or d.AHSC_Project_InprocessData_ID = '6666'
)
BEGIN
ROLLBACK;
RAISERROR('Can not delete this record: this record contains default formula',16,1);
END
ELSE
BEGIN
DELETE [AHSC_Project_InprocessData]
WHERE EXISTS (Select * from deleted d where d.AHSC_Project_InprocessData_ID = [AHSC_Project_InprocessData].AHSC_Project_InprocessData_ID)
END
END发布于 2019-02-02 01:36:56
在删除时使用where条件
delete from ProjectInProcessData where id!=6050https://stackoverflow.com/questions/54484457
复制相似问题