Can I insert today's date in an email?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Can I insert today's date in an email?

Can I insert today's date in an email?

Rate Topic

Display Mode

Topic Options

Author

Message

newdba_sql

Posted Monday, February 11, 2013 11:32 AM

Grasshopper

Group: General Forum Members
Last Login: Today @ 9:29 AM
Points: 12, Visits: 131

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)"

Post #1418583

Ed Wagner

Posted Monday, February 11, 2013 11:46 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:44 AM
Points: 1,856, Visits: 528

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;

Post #1418588

newdba_sql

Posted Wednesday, February 13, 2013 7:28 AM

Grasshopper

Group: General Forum Members
Last Login: Today @ 9:29 AM
Points: 12, Visits: 131

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

Post #1419511

« Prev Topic | Next Topic »

Permissions