如何发送生日祝福的自动电子邮件是从数据库中获取的生日日期 [英] How to send automatic email for birthday wishes were birthday date taken from database

问题描述

如何发送生日祝福的自动电子邮件是从Intranet内的数据库获取的生日日期

How to send automatic email for birthday wishes were birthday date taken from database in the within the intranet

推荐答案

对数据库抛出select语句，确保选择只有那些DOB的月份和日期与当前月份和日期一致的人。

迭代结果集并为每个人发送消息。



提示：请在此处查看： DATEPART（Transact-SQL） [ ^ ]



完成！

Throw a select statement against the database making sure to select only those whose DOB's month and day coincide with the current month and day.
Iterate over the result set and send a message for each one.

Hint: Look at this here: DATEPART (Transact-SQL)[^]

Done!

这篇关于如何发送生日祝福的自动电子邮件是从数据库中获取的生日日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！