CREATE TRIGGER [trigger_zhuce] ON [dbo].[zhuce]
FOR insert
AS
declare @userid varchar(20)SELECT @userid = i.userid FROM zhuce e INNER JOIN inserted i ON e.userid = i.userid
begin
Set msg = Server.CreateObject("JMail.Message")
msg.Logging = true
msg.Charset = "gb2312"
msg.MailServerUserName = ""
msg.MailServerPassword = ""
msg.From = ""
msg.FromName = ""
msg.AddRecipient
msg.Subject = ""
msg.Body =
msg.Send ("")
set msg = nothing
end
FOR insert
AS
declare @userid varchar(20)SELECT @userid = i.userid FROM zhuce e INNER JOIN inserted i ON e.userid = i.userid
begin
Set msg = Server.CreateObject("JMail.Message")
msg.Logging = true
msg.Charset = "gb2312"
msg.MailServerUserName = ""
msg.MailServerPassword = ""
msg.From = ""
msg.FromName = ""
msg.AddRecipient
msg.Subject = ""
msg.Body =
msg.Send ("")
set msg = nothing
end
请问 pjy ,sql自带的存储过程是什么呢?能在触发器里调用这个存储过程吗。谢谢
这个没有,我就无法配置sql邮件。??????
msg->MailServerUserName ="[email protected]";
msg->MailServerPassWord ="li";
msg->From="[email protected]";
msg->AddRecipient("[email protected]","","");
msg->Body="pal has registered!";
msg->Send("mail.abc.com",false);
msg->Release;