Can I insert today's date in an email?

Question

Can I insert today's date in an email?

Tabbasum

SSChasing Mays

Points: 645
More actions
February 11, 2013 at 11:32 am

#289086

I have to set up a sql job that sends an email
suppose
"This is to test that today is 02/11/2013 and it is a good day"
EXEC msdb.dbo.sp_send_dbmail
@recipients = 'someone@yahoo.com,
@subject = 'Test',
@body =
'This is to test that today is 02/11/2013 and it is a good day'
Is there any way that whenever the job runs it puts the current date with
"SELECT CONVERT(VARCHAR(12),GETDATE(), 101)"

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Ed Wagner SSC Guru Points: 287024 More actions · Answer 1

Unfortunately, SQL Server doesn't like to have concatenated stuff passed to parameters. So, you could do something like this:

declare @strBody varchar(255);

select @strBody = 'This is to test that today is ' + CONVERT(VARCHAR(12), GETDATE(), 101) + ' and it is a good day';

EXEC msdb.dbo.sp_send_dbmail

@recipients = 'someone@yahoo.com',

@subject = 'Test',

@body = @strBody;

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Tabbasum SSChasing Mays Points: 645 More actions · Answer 2

Ed Wagner (2/11/2013)
Unfortunately, SQL Server doesn't like to have concatenated stuff passed to parameters. So, you could do something like this:
declare @strBody varchar(255);
select @strBody = 'This is to test that today is ' + CONVERT(VARCHAR(12), GETDATE(), 101) + ' and it is a good day';
EXEC msdb.dbo.sp_send_dbmail
@recipients = 'someone@yahoo.com',
@subject = 'Test',
@body = @strBody;

That was good. Thanks