קוד לשליחת טבלה כ HTML

eldad
Topic Author
Offline
Moderator

14 years 10 months ago #6998 by eldad

קוד לשליחת טבלה כ HTML was created by eldad

DECLARE @tableHTML NVARCHAR(MAX) ;
SET @tableHTML =
N'<html><body><h1>Mail Header</h1>' +
N'<table border="1" width="100%">' +
N'<tr bgcolor="gray"><td>month_key</td><td>Amdocs_day</td></tr>' +
CAST((
SELECT
td = emp_code, '',
td = emp_name, ''
FROM dbo.pool_temp
FOR XML PATH('tr'), TYPE) AS NVARCHAR(MAX)) + N'</table></body></html>'

print @tableHTML

EXEC msdb.dbo.sp_send_dbmail
@recipients=N'mailName@amdocs.com',
@subject = 'SQL Errors Report',
@body = @tableHTML,
@body_format = 'HTML',
@profile_name = N'IMIS_DBA';

Please התחברות to join the conversation.

Moderators: eldad

Time to create page: 0.245 seconds