On Wed, 12 Sep 2001 13:49:07 +0200, "Thomas Nielsen"
<thomas@websup.dk> wrote:
>
>String or binary data would be truncated.
>The statement has been terminated.
>
>Hvad er det nu lige den betyder og hvad kan jeg gøre?
Google search:
"String or binary data would be truncated." SQL
giver som nummer 5
http://vyaskn.tripod.com/programming_faq.htm
hvor man kan læse:
>Why are my insert, update statements failing with the following error?
>Server: Msg 8152, Level 16, State 9, Line 1
>String or binary data would be truncated.
>The statement has been terminated.
>
>This error occurs, when
>the length of the value entered by you into a char,
>varchar, nchar, nvarchar column is longer than the maximum length
>of the column. For example, inserting 'FAQ' into a
>char(2) column would result in this error.
>
>Profiler is handy in troubleshooting this error. If data
>truncation is okay with you and you don't want to see
>this error, then turn off ANSI WARNINGS by using the
>following SET command:
>SET ANSI_WARNINGS OFF.