SqlServer发送邮件

-- =============================================
-- Author:		<Author,SJL,Name>
-- Create date: <Create Date,2015-11-23 10:27:00,>
-- Description:	<Description,发送邮件,>
-- =============================================
CREATE PROCEDURE [dbo].[proc_send_email](
    @error_abstract varchar(100),-- 错误摘要(即简要描述错误信息)
	@error_msg varchar(4000)-- 错误详细信息
	)
AS
BEGIN
	SET NOCOUNT ON;
	
	DECLARE @emailBody VARCHAR(4000); 
	BEGIN 
		SELECT @emailBody='错误摘要：' + @error_abstract + '<br/>错误信息：'+@error_msg + '<br/>时     间：'+ convert(varchar(20),getdate(),20) ; 
		Exec msdb.dbo.sp_send_dbmail 
			@profile_name='SQLMailConfig', 
			@recipients='77777777@qq.com;',<span style="font-family: Arial, Helvetica, sans-serif;">--多个用分号分割</span>
			@subject=@error_abstract, 
			@body=@emailBody,
			@body_format='HTML'

	END
	
END