DECLARE @ptr varbinary(16)
SELECT @ptr = TEXTPTR(TemplateHtml)
FROM [YourDataBase].[dbo].[MarketingEmailTemplates]
WHERE MarketingEmailTemplateID = 1
WRITETEXT [YourDataBase].[dbo].[MarketingEmailTemplates].TemplateHtml @ptr '
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Promo : Free Stuff</title>
<style type="text/css">
<!--
body {
background-color: #d5d5d5;
font-family:Arial, Helvetica, sans-serif;
color:#000;
}
-->
</style>
</head>
<body>
<p>Hello --FULLNAME--</p>
Here is a promo for you.
</body>
</html>'
