[MS SQL] Procedure 最後執行時間
Procedure最後執行時間
SELECT
OBJECT_NAME(object_id) AS ProcedureName,
last_execution_time AS 最後執行時間
FROM
sys.dm_exec_procedure_stats
WHERE
OBJECT_NAME(object_id) <> ''
ORDER BY ProcedureName;參考網址:
By Hao★
[C#] 使用Gmail發送信件
使用Gmail發送信件 using System; using System.Collections.Generic; public void SendMail(string Subject, string Body, IEnumerable ToUser) { string account = "XXX@gmail.com";//登入Mail Server的帳號 string password = "*******";//登入Mail Server的密碼 string from = "XXX@gmail.com";//實際發送信件的Mail地址 string host = "smtp.gmail.com";//發Mail的Server位置 string port = "587";//發Mail的Server位置使用的Port bool enableSsl = true;//是否啟用SSL憑證 System.Net.Mail.MailMessage MyMail = new System.Net.Mail.MailMessage(); MyMail.From = new System.Net.Mail.MailAddress(from); foreach (var i in ToUser) { MyMail.To.Add(i.ToString());//設定收件者Email } MyMail.Subject = Subject; MyMail.Body = Body; //設定信件內容 MyMail.IsBodyHtml = true; //是否使用html格式 System.Net.Mail.SmtpClient MySMTP = new System.Net.Mail.SmtpClient(host, Int32.Parse(port)); MySMTP.Credentials = new System.Net.NetworkCredential(account, password); MySMTP...
留言
張貼留言
歡迎留言