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...