超链接问题解决了,又出了个问题。SET @MBody = '*** Pls do not reply to this mail address. ***' + CHAR(13)
SET @MBody = @MBody + CHAR(13) + '1111111111111111111111111'
SET @MBody = @MBody + CHAR(13) + CHAR(13) + 'http://aaa.bbb.cn/Request.aspx?refno=' + @RefNo
SET @MBody = @MBody + CHAR(13) + CHAR(13) + 'Regards'EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'DBMail',
@recipients = '[email protected]',
@Subject = 'Test',
@body = @MBody,
@body_format = 'HTML'链接有了,可Body中的换行没了,什么问题?怎么解决?
先谢了。
SET @MBody = @MBody + CHAR(13) + '1111111111111111111111111'
SET @MBody = @MBody + CHAR(13) + CHAR(13) + 'http://aaa.bbb.cn/Request.aspx?refno=' + @RefNo
SET @MBody = @MBody + CHAR(13) + CHAR(13) + 'Regards'EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'DBMail',
@recipients = '[email protected]',
@Subject = 'Test',
@body = @MBody,
@body_format = 'HTML'链接有了,可Body中的换行没了,什么问题?怎么解决?
先谢了。
SET @MBody = '*** Pls do not reply to this mail address. ***' + CHAR(13)
SET @MBody = @MBody + CHAR(13) + '1111111111111111111111111'
SET @MBody = @MBody + CHAR(13) + CHAR(13) + 'http://aaa.bbb.cn/Request.aspx?refno=' + @RefNo
SET @MBody = @MBody+'</ br>'
SET @MBody = @MBody + CHAR(13) + CHAR(13) + 'Regards'EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'DBMail',
@recipients = '[email protected]',
@Subject = 'Test',
@body = @MBody,
@body_format = 'HTML'
用字符串拼个</ br>进去就可以了。