T-sql,Mvc,SQL,邮件 [英] T-sql,Mvc, SQL,MAIL
本文介绍了T-sql,Mvc,SQL,邮件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个具有管理员登录ID的表,该表在发送邮件时没有域名,它应该自动获取域名以在sql中发送邮件,我在下面的查询中使用,我需要将@ xxx.com自动添加到收件人邮件中.开始
I have a table with manager login id which doesnt have domain name while sending mail it should automatically fetch domain name to send mail in sql , i used below query , i need to add @xxx.com automatically to recipient mail.. begin
Use [register ]
DECLARE @Receipientlist varchar(8000)
SET @ReceipientList =
STUFF((SELECT ';' + Manager_Login_Id FROM dbo.Idea FOR XML PATH('')),1,1,'')
SELECT
Idea_Id,Login_Id,Manager_Login_Id,Idea_Date_Of_Submission,Idea_Status ='PENDING'
FROM
dbo.Idea
WHERE
Manager_Login_Id IS NOT NULL and Idea_Date_Of_Submission <= DATEADD(day, -5, GETDATE());
EXEC msdb.dbo.sp_send_dbmail
profile_name = '',
recipients = @Receipientlist,
body = 'The DB has changed',
subject = 'DB Change';
推荐答案
如果您的第一个 @RecipientList
变量包含 DOMAIN 用户,则只需将邮件域连接到 Manager_Login_Id
If your first @RecipientList
variable contains the DOMAIN users then you can simply concatenate the mail domain to Manager_Login_Id
Use [register ]
DECLARE @Receipientlist varchar(8000)
SET @ReceipientList =
STUFF((SELECT ';' + Manager_Login_Id+'@xxx.com ' FROM dbo.Idea FOR XML PATH('')),1,1,'')
SELECT
Idea_Id,Login_Id,Manager_Login_Id,Idea_Date_Of_Submission,Idea_Status ='PENDING'
FROM
dbo.Idea
WHERE
Manager_Login_Id IS NOT NULL and Idea_Date_Of_Submission <= DATEADD(day, -5, GETDATE());
EXEC msdb.dbo.sp_send_dbmail
profile_name = '',
recipients = @Receipientlist,
body = 'The DB has changed',
subject = 'DB Change';
这篇关于T-sql,Mvc,SQL,邮件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文