TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Lokesh rapati
NA
29
563
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), '')
Reply
Answers (
1
)
Concatenate Months between two dates
ODBC connection with windows NT authentication