How to insert html code into table using insert statement in Sql server

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hi,

I am trying to insert into following html code into a column using sql query but "incorrect syntax error near Arial" message is coming. This error is coming because of mismatch of opening single code and closing single code.

Please help me to insert bulk of html code like below into table using sql server

"

A. Air Conditioning System of Accommodation Decks & SCR Room

"

insert into Quatations value('

A. Air Conditioning System of Accommodation Decks & SCR Room

')

Thanks,
Santosh

Posted 13-May-14 19:28pm

santoshkumar413

Updated 9-Dec-19 19:47pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DamithSL · Accepted Answer · 2014-05-13T20:25:00

Solution 2

you can use parameter to insert. check below sample code

C#

using (var conn = new SqlConnection("some conn string"))
using (var cmd = conn.CreateCommand())
{
    conn.Open();
    cmd.CommandText = "insert into Table1 (ColumnName) values (@inputHtml)";
    cmd.Parameters.AddWithValue("@inputHtml", inputHtml);
    cmd.ExecuteNonQuery();
}

Posted 13-May-14 20:25pm

DamithSL

Comments

santoshkumar413 14-May-14 2:30am

yeah it also works

Thanks for Your Reply

Aarti Meswania · Accepted Answer · 2014-05-13T19:40:00

Solution 1

Hi,

replace HTML code with single quote (') with ('') then try to insert

e.g.

 hi, It's holiay today

after replace ' with '' statement will like below...

 hi, It''s holiay today

when insert...

SQL

Insert into tblname (colname) values(' hi, It''s holiay today ')

Happy Coding!
:)

Posted 13-May-14 19:40pm

Aarti Meswania

Comments

santoshkumar413 14-May-14 1:48am

But I need to retrieve the record again, after retrieving I need the same format which I have inserted. I need a query which will insert any html content into table irrespective of no. of codes or no. of braces etc.....means inserting whole html data into column like....<html><body><p style='Color:Red;Font-Size:2px'>xyz xyz xyz</p>
<image src="~xyz/xyz.png" alt="image"/>
</body></html>

Aarti Meswania 14-May-14 2:11am

yes you will get same format

Aarti Meswania 14-May-14 2:14am

DECLARE @Temptbl table (col Nvarchar(200))
INSERT INTO @Temptbl (col)
VALUES('<html><body><p style=''Color:Red;Font-Size:2px''>xyz xyz xyz</p><image src="~xyz/xyz.png" alt="image"/></body></html>')
SELECT * FROM @Temptbl

run this and check output

santoshkumar413 14-May-14 2:14am

Hi, thanks for your reply, I found the solution for that, wrote stored procedure and passed parameter into the stored procedure from .cs page in .net

Aarti Meswania 14-May-14 2:30am

ok store-procedure was the best way to do this :)