Reply to Re: How to have strings automatically truncated?

Your name:

Reply:


Posted by John Bokma on 03/02/06 02:56

Erland Sommarskog <esquel@sommarskog.se> wrote:

> John Bokma (john@castleamber.com) writes:
>> "String or binary data would be truncated"
>> Can MS SQL automatically do the truncation?
>
> Yes, if you issue the command SET ANSI_WARNINGS OFF.
>
> However, this is not really recommendable, as there are functionality
> in SQL Server that requires ANSI_WARNINGS to be on.
>
> So you are better off by truncating the data yourself, for instance
> with cast or convert. Or bounce thata over a variable. SQL Server does
> not complain if you assign a variable with an overlong value.

Thanks. Is there an easy way to insert and truncate the data via SQL in
one go (or give something like an "It's ok to truncate hint"? I don't want
to hardcode the max length of a text column (for example) in the program
code.

--
John MexIT: http://johnbokma.com/mexit/
personal page: http://johnbokma.com/
Experienced programmer available: http://castleamber.com/
Happy Customers: http://castleamber.com/testimonials.html

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация