Message
From
04/12/2006 11:23:25
To
04/12/2006 10:38:10
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01174610
Message ID:
01174626
Views:
12
I couldn't work out a way to tell which field was causing the problem so I just used the CAST() function to ensure all string fields were the right length and that solved the problem.
>Hi,
>
>I've got an error when trying to insert some data selected from one table into another:
>
>Msg 8152, Level 16, State 14, Line 8
>String or binary data would be truncated.
>
>Is there any way for me to tell which field it is referring to?
>Hi,
>
>I've got an error when trying to insert some data selected from one table into another:
>
>Msg 8152, Level 16, State 14, Line 8
>String or binary data would be truncated.
>
>Is there any way for me to tell which field it is referring to?