.net自带的System.Web.Mail.MailMessage
解决方案 »
- wpf 字幕动画切换
- xheditor开源编辑器ajax上传功能的完善(精通aspx会看php进)
- DateTimePicker控件,我想替换下拉按钮的图标
- 新年第一次提问???
- 分析查询时出错。 [ Token line number = 1,Token line offset = 15,Token in error = proID ]
- 关于二进制读取出差错的问题(BinaryReader.ReadInt32())
- comboBox控件
- 难啊~~~:请问一个打印的问题!!!大家在帮帮忙,谢谢大家了!!
- 告诉大家C#中如何实现浮动工具栏
- C#连接oracle9时出现了这个问题(报了异常),大家帮帮忙啊
- Hashtable中 如何根据它VALUE得值到KEY值?
- C#中如何把自定义的结构转换成byte[]?
出处:-
作者:未知
SQL SERVER提供了通过EXCHANGE或OUTLOOK收发邮件的扩展存储过程,下面将这几个过程简单的介绍一下。
一、启动SQL Mail
xp_startmail @user,@password
@user和@password都是可选的
也可打开Enterprise Manager中的Support Services,在SQL Mail上单击右键打开右键菜单,然后按Start来启动
二、停止SQL Mail
xp_stopmail
也可用上述方法中的菜单里的Stop来停止
xp_sendmail {[@recipients =] ’recipients [;...n]’} [,[@message =] ’message’] [,[@query =] ’query’] [,[@attachments =] attachments] [,[@copy_recipients =] ’copy_recipients [;...n]’ [,[@blind_copy_recipients =] ’blind_copy_recipients [;...n]’ [,[@subject =] ’subject’] [,[@type =] ’type’] [,[@attach_results =] ’attach_value’] [,[@no_output =] ’output_value’] [,[@no_header =] ’header_value’] [,[@width =] width] [,[@separator =] ’separator’] [,[@echo_error =] ’echo_value’] [,[@set_user =] ’user’] [,[@dbuse =] ’database’]
其中@recipients是必需的
xp_readmail [[@msg_id =] ’message_number’] [, [@type =] ’type’ [OUTPUT]] [,[@peek =] ’peek’] [,[@suppress_attach =] ’suppress_attach’] [,[@originator =] ’sender’ OUTPUT] [,[@subject =] ’subject’ OUTPUT] [,[@message =] ’message’ OUTPUT] [,[@recipients =] ’recipients [;...n]’ OUTPUT] [,[@cc_list =] ’copy_recipients [;...n]’ OUTPUT] [,[@bcc_list =] ’blind_copy_recipients [;...n]’ OUTPUT] [,[@date_received =] ’date’ OUTPUT] [,[@unread =] ’unread_value’ OUTPUT] [,[@attachments =] ’attachments [;...n]’ OUTPUT]) [,[@skip_bytes =] bytes_to_skip OUTPUT] [,[@msg_length =] length_in_bytes OUTPUT] [,[@originator_address =] ’sender_address’ OUTPUT]]
这位大哥,有没有相关的例子给小弟一个嘛,对开发邮件程序这个东西,小弟以前从来没有接触过