34,873
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
nboys 2003-05-27
- 打赏
- 举报
xp_sendmail
happydreamer 2003-05-27
- 打赏
- 举报
/
--Example:
CREATE procedure sp_sendmail
with recompile
as
set datefirst 1
SET QUOTED_IDENTIFIER off
declare
@midept char(5),
@modept char(5),
@mail varchar(30),
@msql varchar(1000),
@mstatus tinyint,
@memo varchar(300),
@msubject varchar(30)
set @mail='kelven@ebtsz.com;ebtszit@ebtsz.com'
select @msql='shsalediscount' --调用过程
select @memo='以下是每天得销售损失情况'+convert(char(10),getdate(),102)
select @msubject='每天得销售损失'
exec @mstatus=master..xp_sendmail @recipients=@mail,
@message=@memo,
@subject=@msubject,
@width=800,
@query=@msql
--Example:
CREATE procedure sp_sendmail
with recompile
as
set datefirst 1
SET QUOTED_IDENTIFIER off
declare
@midept char(5),
@modept char(5),
@mail varchar(30),
@msql varchar(1000),
@mstatus tinyint,
@memo varchar(300),
@msubject varchar(30)
set @mail='kelven@ebtsz.com;ebtszit@ebtsz.com'
select @msql='shsalediscount' --调用过程
select @memo='以下是每天得销售损失情况'+convert(char(10),getdate(),102)
select @msubject='每天得销售损失'
exec @mstatus=master..xp_sendmail @recipients=@mail,
@message=@memo,
@subject=@msubject,
@width=800,
@query=@msql
