从sql触发器发送电子邮件 [英] send email from sql trigger

问题描述

我想将数据库中的电子邮件发送到触发器中的电子邮件地址
通过更新表中的特定列后，我希望将电子邮件发送到某个正文，但是我需要从sql server上执行此操作，我需要它紧急
请我需要任何帮助
关于问候

i want to send email from my database to email address in trigger
by mean after updating specific column in table i want email sent to some body but i need this happen from sql server i need it urgent
please i need any help
with regards

推荐答案

CREATE PROCEDURE dbo.mailsnd AS 
BEGIN 
    SET NOCOUNT ON 
    -- do some other actions 
    DECLARE @body VARCHAR(1024) 
    SET @body = ''foo was fired ''+ 
        CONVERT(VARCHAR, GETDATE()) 
 
    EXEC master..xp_sendmail 
        @recipients=''[e-mail]'', 
        @message = @body, 
        @subject = ''mail was fired.'' 
END 
 
-- or you can do it conditionally: 
 
CREATE PROCEDURE dbo.mailsnd AS 
BEGIN 
    SET NOCOUNT ON 
    -- do some other action 
    IF @@ROWCOUNT > 0 
    BEGIN 
        DECLARE @body VARCHAR(1024) 
        SET @body = ''foo was fired '' + 
            CONVERT(VARCHAR, GETDATE()) + 
            CHAR(13) + CHAR(10) +  
            CONVERT(VARCHAR, @@ROWCOUNT) 
 
        EXEC master..xp_sendmail 
            @recipients=''[e-mail]'', 
            @message = @body, 
            @subject = ''mail was fired.'' 
    END 
END

您好，请查看以下链接:



http://www.sql-server-performance.com/2006/email-functionality/ [ ^ ]

http://support.microsoft.com/kb/263556 [

Hello please look into following links :



http://www.sql-server-performance.com/2006/email-functionality/[^]

http://support.microsoft.com/kb/263556[^]

这篇关于从sql触发器发送电子邮件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！