Better Explanation With Escape Character Issue

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Better Explanation With Escape Character Issue

Author

Topic

filipinoheat
Starting Member

8 Posts

Posted - 2006-07-27 : 13:18:22

I'm sorry if I'm not being clear but this is what I'm trying to do. I'm trying to update a table with new descriptions inside an html tags. I'm using query analyzer to query the table, but unfortunately it does not display the full result. So to resolve this issue is that I export result into notepad by using bcp utility and modify the things that I need, copy and paste it onto my update query like this:

update myTable
set faq_text = ' BVIG Financial Frequently Asked Questions 
 <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p>
<o:p></o:p>
<o:p></o:p>
<H4 class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p></o:p>'

But this gives me an error since the html tag attributes are using single quotes. I thought T-SQL would have escape chracters like C#.

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2006-07-27 : 13:25:38

dupe post:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=69653

Be One with the Optimizer
TG

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-07-27 : 16:46:13

heat - you should really put this message in the original thread.

that could potentially help someone later if they had a similar issue.

-ec

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources