EXEC master.dbo.xp_sendmail
@recipients ='kevin',
@subject='近期有未审核的单据',
@message='ERP系统检测到近期有未审核的单据,影响库存数据的准确性,请速处理!
──────────────────────────────────',
@query = 'select CONVERT(VARCHAR(10),dDate,121) AS 日期 ,CCODE AS 单号 from UFDATA_007_2009.DBO.RdRecord where cHandler is null'***************************************************
我写了上面这一段语句想作为存储过程每天一次向相关收件人发送邮件,若qurey查询无结果时,邮件将不发送!
我该怎样修改语句才能处理,qurey查询无结果时,邮件将不发送?
@recipients ='kevin',
@subject='近期有未审核的单据',
@message='ERP系统检测到近期有未审核的单据,影响库存数据的准确性,请速处理!
──────────────────────────────────',
@query = 'select CONVERT(VARCHAR(10),dDate,121) AS 日期 ,CCODE AS 单号 from UFDATA_007_2009.DBO.RdRecord where cHandler is null'***************************************************
我写了上面这一段语句想作为存储过程每天一次向相关收件人发送邮件,若qurey查询无结果时,邮件将不发送!
我该怎样修改语句才能处理,qurey查询无结果时,邮件将不发送?
if exists('select CONVERT(VARCHAR(10),dDate,121) AS 日期 ,CCODE AS 单号 from UFDATA_007_2009.DBO.RdRecord where cHandler is null' )
EXEC master.dbo.xp_sendmail
@recipients ='kevin',
@subject='近期有未审核的单据',
@message='
ERP系统检测到近期有未审核的单据,影响库存数据的准确性,请速处理!
──────────────────────────────────',
@query = 'select CONVERT(VARCHAR(10),dDate,121) AS 日期 ,CCODE AS 单号 from UFDATA_007_2009.DBO.RdRecord where cHandler is null'
第 1 行: 'select CONVERT(VARCHAR(10),dDate,121) AS 日期 ,CCODE AS 单号 from UFDATA_007_2009.DBO.RdRecord where cHandler is null' 附近有语法错误。