SQLTeam.com | Weblogs | Forums

Database mail

#1

Dear Team,

I have a T-SQL query like this
If
(select Count(*) from DC where tdate > CONVERT(INT, CONVERT(VARCHAR, getdate()+1,112)) and fty_from = 'Del') >0
Print 'OK'
Else Print'Not OK'

now i want to send a database mail in which it can display the query result. Please help

thanks in advance

0 Likes

#2

You may need to use HTML in your SQL to send the results via dbmail.

0 Likes