GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SendMail]
AS
DECLARE @vcMailAddress varchar(255)
declare @ccMailAddress varchar(255)
DECLARE @FROM varchar(100)
DECLARE @TO varchar(255)
DECLARE @subject varchar(100)
DECLARE @message varchar(2000)
DECLARE @type varchar(100)
DECLARE @server varchar(100)
SET @vcMailAddress = 'xxxxx@qq.com;'
SET @ccMailAddress ='xxxxxx@qq.com;'
if @PJCD is not null
begin
SET @FROM = '发件人'
SET @subject = ‘主题’
SET @type = 'text/html'
SET @server = '邮件服务器'
SET @message = '邮件内容'
end
EXEC master.dbo.xp_smtp_sendmail --sqlserver自带邮件发送函数
@FROM = @FROM
,@TO = @vcMailAddress
,@CC=@ccMailAddress
,@subject = @subject
,@message = @message
,@type = @type
,@server =@server