Mensaje
De
04/12/2006 11:41:03
a
04/12/2006 11:23:25
General information
Foro:
Microsoft SQL Server
Category:
Sintáxis SQL
Título:
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
ID de la conversación:
01174610
ID del mensaje:
01174630
Views:
9
>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?
Where you execute this statement?
if in QA go to line 8 and see what fields you have on that line.
>
>
>>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?
Where you execute this statement?
if in QA go to line 8 and see what fields you have on that line.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
The only thing normal about database guys is their tables.