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
SQL 發郵件
最新推荐文章于 2023-06-30 10:59:02 发布