DECLARE @body NVARCHAR(MAX)
DECLARE @mSubject VARCHAR(MAX);
DECLARE @date DATETIME;
SET @date = CAST(CONVERT(CHAR(10), GETDATE(), 101) AS DATETIME);
SET @body = '<html><head>
<title>Email Başlık</title>
</head><body>
<table border="1" cellpadding="0" cellspacing="0" width="100%">
<tr style="text-align:left";>
<th>Plaka</th>
<th>İl</th>
<th>İlçe</th>
<th>Adres</th>
</tr>';
SET @body = @body + CAST(
(
SELECT
'td/@align' = 'left',
td = T.Plaka,
'',
'td/@align' = 'left',
td = T.IlAdi,
'',
'td/@align' = 'left',
td = T.IlceAdi,
'',
'td/@align' = 'left',
td = T.Adres,
''
From (
SELECT * FROM Adres
) T
FOR XML PATH('tr'), ELEMENTS
)
AS NVARCHAR(MAX))
SET @body = @body + '</table></body></html>';
SET @mSubject = 'Falcon - ' + CONVERT(CHAR(10), DATEADD(dd, -1, @date), 104) + ' Konumu Çekilemeyen Adresler';
EXEC msdb.dbo.sp_send_dbmail
@recipients = N'akifyanbak@mail.com',
@copy_recipients =N'cc@mail.com',
@body = @body,
@body_format = 'HTML',
@subject = @mSubject,
@profile_name = 'sql_email_profile';
3 Aralık 2020 Perşembe
MSSQL Email Gönderme
Kaydol:
Kayıt Yorumları (Atom)
Hiç yorum yok:
Yorum Gönder