Home Forums SQL Server 2005 Administering String or binary data would be truncated. RE: String or binary data would be truncated.

  • September 27, 2012 at 7:30 am

    #1542884

    Hi,

    Before inserting the data, find out what the MAX(LEN(Col)) is for each column. Compare the results to your variable declarations and destination table design.

    Btw, varchar(max) isn't recognized in SQL 2000. Better find out what it needs to be at the moment and add a little buffer. But if must be as big as possible use varchar(8000) instead.

    Goodluck.


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort