SQL 發郵件

CREATE PROCEDURE [dbo].usp_SendEmailhtml       
       
@TONameList varchar(3000), --收件名單                 
       
@CCNameList varchar(3000), --副本名單                 
       
@SubjectString nvarchar(100),   --主旨           
       
@BodyString nvarchar(max),     --內容               
       
@bodyformat varchar(max)       
       
as          
        
       
begin                
       
set nocount on                 
       
                 
       
exec msdb.dbo.sp_send_dbmail @recipients =@TONameList            
       
,@copy_recipients =@CCNameList,@subject =@SubjectString,@body = @BodyString,@body_format=@bodyformat       
       
   
set nocount off             
       
end