问题描述
我想知道如何使用sql server自动发送用户数据库的选择"查询结果的电子邮件.因为根据状态报告，我必须每天向 HO 发送少量报告.请帮助我完成..
I want to know how can we send automatically email of the 'select' query results of User database with sql server. As i have to send few reports on daily basis to HO for as per status reports.Kindly help me through..
谢谢
推荐答案
您应该查看 SSRS 的订阅和交付部分.此处链接 - 订阅在交付方案中查找电子邮件.此外，如果您将这些报告发送给固定的 HO，那么普通的标准订阅就可以为您服务，否则如果您的 HO 根据 sql 查询更改，则查找 数据驱动的订阅.
You should look into Subscriptions and Delivery part of SSRS. Link here - SubscriptionsIn delivery scenarios look for E-mail. Also if you are sending those reports to a fixed HO then normal standard subscriptions will do for you, else if your HO changes based on sql query then look for data-driven subscriptions.
这篇关于SSRS 数据获取和电子邮件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！