如何利用SQL Server來發(fā)送電子發(fā)郵件

1、如何利用SQL Server來發(fā)送電子發(fā)郵件？ 如何利用SQL Server發(fā)送郵件？ 在SQL Server中，提供了通過Exchange或Outlook收發(fā)郵件的擴(kuò)展存儲(chǔ)過程。下面簡單地介紹一下：一、啟動(dòng)SQL Mail：xp_startmail user,password其中，user和password都是可選的。     也可打開Enterprise Manager中的Support Services，在SQL Mail上單擊右鍵打開右鍵菜單，然后按Start來啟動(dòng)二、停止SQL Mail   &

2、#160;xp_stopmail    也可用上述方法中的菜單里的Stop來停止三、發(fā)送郵件    xp_sendmail recipients = 'recipients ;.n'         ,message = 'message'         ,query = 'query'  

3、0;      ,attachments = attachments         ,copy_recipients = 'copy_recipients ;.n'        ,blind_copy_recipients = 'blind_copy_recipients ;.n'     &

4、#160;  ,subject = 'subject'        ,type = 'type'         ,attach_results = 'attach_value'        ,no_output = 'output_value'   

5、      ,no_header = 'header_value'         ,width = width         ,separator = 'separator'         ,echo_error = 'echo_value' &

6、#160;       ,set_user = 'user'         ,dbuse = 'database' 參數(shù)說明：序號(hào)參 數(shù)說 明備 注1recipients收件人。多人中間用逗號(hào)分開必需2message要發(fā)送的信息3query確定執(zhí)行并依附郵件的有效查詢除觸發(fā)器中的插入表及刪除表外，此查詢能引用任何對(duì)象4attachments附件5copy_recipients抄送blind_copy_r

7、ecipients密送subject標(biāo)題attach_results指定查詢結(jié)果做為附件發(fā)送no_header不發(fā)送查詢結(jié)果的列名set_user查詢聯(lián)接的用戶名默認(rèn)為Gusetdbuse查詢所用的數(shù)據(jù)庫默認(rèn)為缺省數(shù)據(jù)庫四、閱讀郵件收件箱中的郵件    xp_readmail msg_id = 'message_number' , type = 'type' OUTPUT         ,peek = 'peek' 

8、       ,suppress_attach = 'suppress_attach'        ,originator = 'sender' OUTPUT        ,subject = 'subject' OUTPUT       

9、0;,message = 'message' OUTPUT        ,recipients = 'recipients ;.n' OUTPUT        ,cc_list = 'copy_recipients ;.n' OUTPUT        ,bcc_list = 'blind_copy

10、_recipients ;.n' OUTPUT        ,date_received = 'date' OUTPUT        ,unread = 'unread_value' OUTPUT        ,attachments = 'attachments ;.n' OUTPUT 

11、;       ,skip_bytes = bytes_to_skip OUTPUT        ,msg_length = length_in_bytes OUTPUT        ,originator_address = 'sender_address' OUTPUT    參數(shù)說明：序號(hào)參 數(shù)說 明備

12、 注1originator發(fā)件人2subject主題3message信息4recipients收件人5skip_tytes讀取郵件信息時(shí)跳過的字節(jié)數(shù)用于順序獲取郵件信息段6msg_length確定所有信息的長度通常與5一起處理長信息五、處理下一個(gè)郵件：    xp_findnextmsg msg_id = 'message_number' OUTPUT         ,type = type      

13、60;  ,unread_only = 'unread_value'六、刪除郵件：    xp_deletemail 'message_number'    如果不指定郵件編號(hào)則刪除收件箱中的所有郵件七、自動(dòng)處理郵件：    sp_processmail subject = 'subject'        ,filetype = 'filetype'   &#