[MS SQL] SQL Server 寄送郵件(sp_send_dbmail)

sp_send_dbmail使用 

EXEC msdb.dbo.sp_send_dbmail 
@profile_name='MES_MAIL',
@recipients='eMail Address',
@blind_copy_recipients='eMail Address',
@subject = '主旨',
@body = '內容',
@body_format = 'HTML';

SELECT * FROM msdb.dbo.sysmail_allitems --查詢寄送的郵件記錄
參考網址: 

留言

張貼留言

歡迎留言

熱門文章

[Java] equals()、equalsIgnoreCase()

equals( ) Code: public static void main(String[] args) { String s1 = "hello"; if(s1.equals("hello")) System.out.println("s1 equals hello"); else System.out.println("s1 not equals hello"); } 輸出： s1 equals hello equalsIgnoreCase( )  Code: public static void main(String[] args) { String s1 = "hello"; String s2 = "Hello"; if(s1.equalsIgnoreCase(s2)) System.out.println("s1 equals s2"); else System.out.println("s1 not equals s2"); } //equalsIgnoreCase會忽略大小寫 輸出： s1 equals s2 By Hao★
閱讀完整內容

[C#] 將DataTable轉換成Html格式表格

將DataTable轉換成Html格式表格   using System.Data; using System.Text; protected string ExportDatatableToHtml(DataTable dt) { StringBuilder strHTMLBuilder = new StringBuilder(); strHTMLBuilder.Append("<table border='2px' cellpadding='5'>"); strHTMLBuilder.Append("<tr>"); foreach (DataColumn myColumn in dt.Columns) { strHTMLBuilder.Append("<td>"); strHTMLBuilder.Append(myColumn.ColumnName); strHTMLBuilder.Append("</td>"); } strHTMLBuilder.Append("</tr>"); foreach (DataRow myRow in dt.Rows) { strHTMLBuilder.Append("<tr>"); foreach (DataColumn myColumn in dt.Columns) { strHTMLBuilder.Append("<td>"); strHTMLBuilder.Append(myRow[myColumn.ColumnName].ToString()); strHTMLBuilder.Append("</td>"); } strHTMLBuilder.Append...
閱讀完整內容

[Java] startsWith()、endsWith()

startsWith( ) Code: public static void main(String[] args) { String s1 = "Hello World"; if(s1.startsWith("Hello")) System.out.println("s1 starts with Hello"); if(s1.startsWith("W",6)) System.out.println("s1 starts with W at position 6"); } 輸出： s1 starts with Hello endsWith( )  Code: public static void main(String[] args) { String s1 = "Hello World"; if(s1.endsWith("World")) System.out.println("s1 ends with World"); } 輸出： s1 ends with World By Hao★
閱讀完整內容