Passing Html tag in Update query <p>There is an existing table in database where I want to update one column. If I right click on the table--->select edit 200 rows and try to edit the cell data it says that the cell is read-only. I am using SQL management studio 2008R2. So I was trying to update it using an update Query but I am pretty new to the SQL queries and the whole database thing. Is this the proper way to pass an HTML tag in queries?</p> <pre><code>UPDATE OutputTemplate SET emailText='(&lt;p&gt;Thank you for your gift of {Amount} to the {CommunityName}&lt;/p&gt;&lt;br /&gt;Support &amp; Charity Campaign.&lt;br /&gt; -------------------------------------------- --- Transaction Detail --- -------------------------------------------- &lt;span&gt;Credit Card Details&lt;/span&gt; &lt;span style="text-decoration: underline;"&gt;Personal Info Details &amp; Amount&lt;/span&gt;)' WHERE id='2' </code></pre> <p>It's showing some parsing error, incorrect syntax while executing the query.</p> <p>Sorry to ask such a basic question but I tried to google it, unfortunatelly nothing showed up useful.</p> <p>Thanks </p>