How to format HTML in sql server 2005

Posted by Anonymus under Sql Server on 10/11/2012 | Points: 10 | Views : 1091 | Status : [Member] | Replies : 0
I am having a stored procedure that files email notification. In the body section I want next line tags <br/> to be incorporated in SQL server so as when a email is received the content is properly presented by line break.
In my stored procedure I am writing following :

@Body = 'My Name ' + @Name + '<br/>'+ 'Registration Number : ' @RNo + '<br/>' etc...

However, this gives me error as incorrect syntax near +.

Basically, I need to incorporate the HTML tags properly in my SQL server script. Please help...



(No response found.)

Login to post response