如何在SQL IF EXISTS中设置两个变量

社会学

我需要在IF EXISTS语句中设置两个变量。第一个是更改电子邮件的主题，第二个是更改收件人列表。请帮忙..谢谢

SET DATEFORMAT mdy;
GO
DECLARE @datevar date = getdate();
DECLARE @subjectCheck AS NVARCHAR(MAX);
DECLARE @email AS NVARCHAR(MAX);


IF EXISTS (SELECT CurrentDate from LOG_SHIP_CHECK WHERE CurrentDate = @datevar)
 SET @subjectCheck = 'Check LogShip: Success'
 SET @email = '[email protected]'
 ELSE
SET @subjectCheck = 'Check LogShip: Failure'; @email = '[email protected]'
DECLARE @tableHTML  NVARCHAR(MAX) ;

SET @tableHTML =
    N'<H1>Ezis Raadpleeg</H1>' + 
    N'<table border="1">' +
    N'<th>Datum</th></tr>' +
    CAST ( ( SELECT td = CurrentDate 
              FROM LOG_SHIP_CHECK 
             FOR XML PATH('tr'), TYPE 
    ) AS NVARCHAR(MAX) ) +
    N'</table>' ;

EXEC msdb.dbo.sp_send_dbmail @profile_name = 'ProfileName', @recipients=@email,
    @subject = @subjectCheck,
    @body = @tableHTML,
    @body_format = 'HTML' ;

苏拉瓦

IF EXISTS (SELECT CurrentDate from LOG_SHIP_CHECK WHERE CurrentDate = @datevar)
BEGIN
 SET @subjectCheck = 'Check LogShip: Success';
 SET @email = '[email protected]';
END
ELSE
BEGIN
 SET @subjectCheck = 'Check LogShip: Failure';
 SET @email = '[email protected]';
END

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。