Lokesh rapati

Lokesh rapati

  • NA
  • 29
  • 550

beautifying in SQL

Oct 26 2018 12:24 AM
Hi ,
 
I am using SQL server 2008 and in need a help regarding beautifying a msg line that displays in Email body .can any one help me in doing that.
 
Below is the message line  
 
@msg nvarchar(max)='The Certificate/Password for '+ISNULL(@cert, '') + ISNULL(@user, '')++' of '+@App+' on server '+@server+' is expiring on '+ Coalesce(Convert(Varchar, @date), '')  

Answers (1)