I'm trying to insert the following statement into MSSQL DB, the field type
is text but is not inserted completely, it's truncated. can anyone help?
statement
UPDATE Table
SET BodyEn = '<p align="left"
class="header_black"><strong>Terms of Use </strong> </p>
<p align="left"> company test Telecom and related
companies ("company Telecom"), ("company International)
provides access to and allows use of this site (www.company-test.com)
subject to the following terms:<br />
1. By using www.company-test.com you agree to
be legally bound by these terms, which shall take effect immediately on
your first use of www.company-test.com. If you do not agree to be legally
bound by all the following terms, please do not access and/or use
www.company-test.com.<br <http://www.company-test.com.%3cbr/> />
<br />
2. company test Telecom may change these terms
at any time by posting changes online. Please review these terms regularly
to ensure you are aware of any changes made by company test Telecom. Your
continued use of www.company-test.com after changes are posted means you
agree to be legally bound by these terms as updated and/or amended. </p>
<p align="left" class="header_black"><strong>Use of
www.company-test.com</strong <http://www.company-test.com%3c/strong>> </p>
<p align="left"> 3. You may not copy, reproduce,
modify, transfer, distribute, republish, download, post, broadcast,
transmit, make available to the public, or otherwise use the content on
this site (content includes but is not limited to text, layout,
information, communications, software, sounds, names images, pictures,
logos, icons, apparatus, product or process) in any form or by any means
(including but not limited to electronic, mechanical photocopying or
recording) except for your own personal, non-commercial use. You also agree
not to adapt, alter or create a derivative work from any
www.company-test.com content. Any other use of www.company-test.com content
requires the prior written permission of company test Telecom. <br />
You understand and agree that you are responsible
for any content that you post or transmit on or through this site. You
agree not to cause, nor knowingly allow others to cause, any nuisance,
annoyance, or inconvenience, whether to company test Telecom or users of
www.company-test.com by any means.<br />
4. You agree to use www.company-test.com only for
lawful purposes, in a manner consistent with all applicable laws and
regulations and in a way that does not infringe the rights of, restrict or
inhibit anyone else"s use and enjoyment of www.company-test.com.
Specifically, you will not use www.company-test.com to post, transmit,
distribute, link to or solicit content that (a) violates or infringes any
laws, regulatory requirements or codes (b) infringes or violates any
copyright, trademark or any other intellectual property, personal or
proprietary rights of any person, or violates any obligation of confidence
or any other proprietary right; (c) contains any obscene, offensive,
defamatory or otherwise actionable material; (d) disrupts the normal flow
of dialogue within companytelecomtest.com; (e) undermines the security or
integrity of companytelecomtest.com, including without limitation by
importing any viruses, Trojan horses, time bombs or other disabling devices
intended to detrimentally interfere, damage, surreptitiously intercept or
expropriate such equipment, systems or networks; (f) contains any errors,
whether technical or otherwise; or (g) contains any material in any form
that would otherwise render company test Telecom liable or expose company
test Telecom to any proceedings whatsoever.<br />
5. You may not use any robot, spider, or other
automatic or manual device or process to monitor or copy our web pages or
any portion of the content contained herein without the express prior
written permission of company test Telecom.<br />
6. You may not use any device, software or
routine to interfere or attempt to interfere with the proper working of
www.company-test.com, or to impose an unreasonable or disproportionately
large load on the servers serving
www.company-test.com.<br<http://www.company-test.com.%3cbr/>/>
7. company test Telecom shall have the right (but
not the obligation) in its sole discretion to monitor, refuse or remove any
content that is available via www.company-test.com. Without limiting the
foregoing, company test Telecom shall have the right to remove any content
that violates these terms or is otherwise objectionable.</p>
<p align="left" class="header_black"><strong>Content
Posted or Submitted to company test Telecom</strong> </p>
<p align="left"> 8. company test Telecom freely
welcomes the submission of comments, information, or feedback through
www.company-test.com, by all means and in any media now known or hereafter
developed. By submitting information through this site you agree that the
information shall not be considered confidential and shall become the
property of company test Telecom, including an assignment of all rights and
titles to such information. Where assignment is not possible, company test
Telecom shall have the unrestricted right to use such information, with
right to reproduce, distribute, transmit, create derivative works of,
publicly display and publicly perform any materials and other information
(including, without limitation, ideas contained therein for new or improved
products and services) you submit to www.company-test.com, for any purpose
and without compensation to you. You also grant to company the right
(though you acknowledge and agree that company test Telecom shall not be so
obliged) to use your name in connection with the submitted materials and
other information as well as in connection with all advertising, marketing
and promotional material related thereto. You agree that you shall have no
recourse against company test Telecom for any alleged or actual
infringement or misappropriation of any proprietary right in your
communications to us. <br />
9. Except for any personal, individually
identifying information which we have agreed to keep confidential, any
feedback, data, answers, questions, comments, suggestions, plans, ideas or
the like that you send to us via www.company-test.com, via e-mail or
otherwise, will be treated as being non-confidential and non-proprietary.
We assume no obligation to protect such information from disclosure and
will be free to reproduce, use, and distribute the information to others
without restriction. We will also be free to use any ideas, concepts,
know-how or techniques contained in information that you send us for any
purpose whatsoever including but not limited to developing, manufacturing
and marketing products and services incorporating such information.</p>
<p align="left"
class="header_black"> <strong>Postings by Third
Parties and Hyperlinks to Third Party Websites</strong></p>
<p align="left"> 10. www.company-test.com contains
hyperlinks to other websites which are neither maintained nor controlled by
company test Telecom, or may contain content posted on or via
www.company-test.com by third parties. company test Telecom shall not be
responsible for any errors or omissions in any content in
www.company-test.com, or the content, products or services of any
hyperlinked website or any hyperlink contained in a hyperlinked web site,
nor for the privacy and security practices employed by these other
websites, and shall not be liable for any loss or damage of any kind
incurred as a result of the use of any content posted or contained in
e-mails or otherwise transmitted or displayed via www.company-test.com, or
arising from access to those websites. Use of www.company-test.com and any
hyperlinks and access to such hyperlinked websites are entirely at your own
risk.<br />
11. You acknowledge that company test Telecom has
no control over and excludes all liability for any material on the Internet
which can be accessed by using www.company-test.com. Neither can we be
deemed to have endorsed the content.</p>
<p align="left"
class="header_black"><strong>Hyperlinks from Third Party Websites</strong>
</p>
<p align="left"> 12. You agree that caching,
deep-linking, hyper linking to, and framing of www.company-test.com or any
of the contents are strictly prohibited.<br />
13. company test Telecom reserves all rights to
disable any links to, or frames of any site containing inappropriate,
profane, defamatory, infringing, obscene, indecent or unlawful topics,
names, material or information, or material or information that violates
any written law, any applicable intellectual property, proprietary, privacy
or publicity rights.</p>
<p align="left"
class="header_black"><strong>Disclaimers and Limitation of
Liability</strong> </p>
<p align="left"> 14. You assume total responsibility
and risk for your use of www.company-test.com and the Internet. Neither
company test Telecom nor any content provider makes any express or implied
warranties, representations or endorsements whatsoever with regard to
www.company-test.com, any content or any merchandise, information or
service provided through www.company-test.com or on the Internet</p>'
WHERE (ID = 41)
--
Kind Regards,
Mohammad Al-Naji
[Non-text portions of this message have been removed]
