--参考 CREATE TRIGGER INSERT_GTBH ON GTBH FOR INSERT AS DECLARE @MESSAGEBOX VARCHAR(250) DECLARE @GTBH_CODE VARCHAR(17) DECLARE @GBH_SUM NUMERIC(15,2) SELECT @GTBH_CODE=A.gtbh_code,@GTBH_FROM=A.c_code FROM inserted A set @messagebox=@gtbh_code+ ' '+@gtbh_from EXEC master..XP_SENDMAIL '[email protected] ',@messagebox GO
create trigger trg_t on t for insert as begin if exists(select 1 from inserted where colname=0) begin exec xp_sendmail ... end end
create trigger tr_g on a for insert as begin if exists(select 1 from inserted where colname=0) begin exec xp_sendmail end end
CREATE TRIGGER INSERT_GTBH
ON GTBH
FOR INSERT
AS
DECLARE @MESSAGEBOX VARCHAR(250)
DECLARE @GTBH_CODE VARCHAR(17)
DECLARE @GBH_SUM NUMERIC(15,2)
SELECT @GTBH_CODE=A.gtbh_code,@GTBH_FROM=A.c_code FROM inserted A
set @messagebox=@gtbh_code+ ' '+@gtbh_from
EXEC master..XP_SENDMAIL '[email protected] ',@messagebox
GO
create trigger trg_t on t
for insert
as
begin
if exists(select 1 from inserted where colname=0)
begin
exec xp_sendmail ...
end
end
for insert
as
begin
if exists(select 1 from inserted where colname=0)
begin
exec xp_sendmail
end
end