Database mail

Other SQL Server Topics
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

2

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