title: HTMl Anchor tag in stored procedure
body: <p>i want to use a anchor tag in stored procedure that would be sent as a body of the mail and it's not working</p>
  
  <pre><code>declare @loginlink VARCHAR(MAX)=N'';
  </code></pre>
  
  <p>SELECT @loginlink= N'<a href="http://localhost/Project/CaseHistory/History?caseId=" rel="nofollow">'+ CONVERT(varchar(36),@loginlink)+'ClickMe </a>' AS CaseLink</p>