DECLARE @tableHTML NVARCHAR(MAX) ;
DECLARE @tableDate datetime ;
SET @tableDate = getdate()
SET @tableHTML=
N' HTML Header
' +
N'
N'' +
'
EXEC msdb.dbo.sp_send_dbmail
@recipients=N'test@test.com',
@body= @tableHTML,
@subject ='xyz',
@body_format = 'HTML',
@profile_name = 'ProfileName'
DECLARE @tableDate datetime ;
SET @tableDate = getdate()
SET @tableHTML=
N' HTML Header
' +
N'
HTML Header 1
' +N'
Id | Name | ' +
---|
EXEC msdb.dbo.sp_send_dbmail
@recipients=N'test@test.com',
@body= @tableHTML,
@subject ='xyz',
@body_format = 'HTML',
@profile_name = 'ProfileName'
Comments
Post a Comment