ALTER TRIGGER [dbo].[ICStockBill_DEL]
ON [dbo].[ICStockBill]
FOR DELETE
AS
SET NOCOUNT ON
IF EXISTS (SELECT 1 FROM DELETED WHERE FCheckerID <> 0)
BEGIN
ROLLBACK TRAN
RAISERROR('不能删除已经审核的单据!',18,18)
END
ELSE IF EXISTS (SELECT 1 FROM DELETED WHERE FCancellation = 1)
BEGIN
ROLLBACK TRAN
RAISERROR('不能删除已经作废的单据!',18,18)
END
ELSE
DELETE E
FROM ICStockBillEntry E
INNER JOIN deleted D ON E.FInterID = D.FInterID
SQLSERVER触发器中带提示的例子
于 2023-05-15 11:07:20 首次发布