Re: string or binary data would be truncated

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 07/18/04 

Date: Sun, 18 Jul 2004 12:14:50 +0100

Try this: http://vyaskn.tripod.com/programming_faq.htm#q1 

-- 
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"string or binary data would be truncated" <string or binary data would be
truncated@discussions.microsoft.com> wrote in message
news:BE19CD0D-54BC-4986-A92C-C218119D7DBE@microsoft.com...
> I get this error during updating the tables. Is there any way to add
forcibly the truncated values into the table.
>
> regards

Relevant Pages

  • Re: Variable WHERE part of SELECT command
    ... "William Vaughn" wrote in message ... you can create a Table-returning Function that converts a delimited string to a table. ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: bytes to string conversion
    ... I can connect sql server and retrive the data intoi the DataSet. ... mPASSWQORD field uses binary data type. ... I have to convert this binary data into the string so I can compare it. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Starting from the beginning
    ... Then, it usses an English-language string in the source code, which is ... possible reasons into the useless and incomprehensible "Unable to open CIP file", ... // more processing will be done here like getting the binary data ... /CIP3PreviewImageHeight 726 def ...
    (microsoft.public.vc.mfc)
  • Re: Searching for byte sequence
    ... Several lines of "text" header info followed by 10,000bytes of binary data ... like your text string) then the Find approach will work. ... If n gives me an offset in a string (that ... CString cSelect; ...
    (microsoft.public.vc.mfc)
  • RE: Strange issue while executing sql server sp
    ... references a string or binary data, so it probably isn't the ctns column. ... I have a simple stored procedure in sql server 2005 express version. ...
    (microsoft.public.sqlserver.programming)