6,129
社区成员
发帖
与我相关
我的任务
分享
USE [szfc_k3]
GO
/****** Object: Trigger [dbo].[ICStockBill_XZZWRQ] Script Date: 10/31/2017 15:00:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER trigger [dbo].[ICStockBill_XZZWRQ] on [dbo].[ICStockBill]--限制账务日期
for update,insert
as
set nocount on
declare @finterid int
select @finterid=finterid from inserted
if exists(select 1 from icstockbill a inner join icstockbillentry b on a.finterid=b.finterid
where ( a.FDate like '%30%')
and a.FInterID=@finterid and a.FStatus=0)
begin
raiserror('账务日期错误!!!',18,18)
rollback tran
return
end
set nocount off
IF EXISTS(SELECT 1 FROM sys.triggers AS t WHERE t.is_disabled=0 AND t.name='ICStockBill_XZZWRQ')
BEGIN
--发送邮件
EXEC msdb..sp_send_dbmail
@profile_name = 'ErrorEmailProfile',
@recipients = 'xxxxx@qq.com', --收件人,你的邮件
@subject = '预警:该死的触发器又启用了!',
@body = N'该死的触发器 ICStockBill_XZZWRQ 又启用了!'
END