Message
From
04/12/2006 14:10:04
To
04/12/2006 11:41:03
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01174610
Message ID:
01174694
Views:
9
Hi Borislav,
I wish it were so easy, but line 8 did not have anything to do with the problem (I was running it in SSMS in a query). Anyhow, it's all solved now.
>>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.
I wish it were so easy, but line 8 did not have anything to do with the problem (I was running it in SSMS in a query). Anyhow, it's all solved now.
>>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.