declare @ccbill varchar(8),@sql varchar(500)
set @ccbill='system'
set @sql='select distinct ino_id as 凭证号,cbill as 制证人 from abc where cbill='''+@ccbill+''''
exec master.dbo.xp_sendmail @recipients='[email protected]'
,@subject='请检查系 统生成的如下凭证'
,@query=@sql
,@dbuse= 'yourdatabase'
--说明:yourdatabase 是 表abc所在的数据库
set @ccbill='system'
set @sql='select distinct ino_id as 凭证号,cbill as 制证人 from abc where cbill='''+@ccbill+''''
exec master.dbo.xp_sendmail @recipients='[email protected]'
,@subject='请检查系 统生成的如下凭证'
,@query=@sql
,@dbuse= 'yourdatabase'
--说明:yourdatabase 是 表abc所在的数据库
exec "master.dbo.xp_sendmail '[email protected]','请检查系 统生成的如下凭证','select distinct ino_id as 凭证号,cbill as 制证人 from abc where cbill='"+@ccbill+"'"
应该是:
declare @ccbill varchar(8),@mess varchar(100),@query varchar(100)
select @ccbill='system',
@query ='select distinct ino_id as 凭证号,cbill as 制证人 from abc where cbill =' + @ccbill exec master.dbo.xp_sendmail @recipients='[email protected]',
@subject='请检查系 统生成的如下凭证',
@query =@query