I have a T-SQL query like this
(select Count(*) from DC where tdate > CONVERT(INT, CONVERT(VARCHAR, getdate()+1,112)) and fty_from = 'Del') >0
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