SQL 2005 Question
Posted on 2009-12-24
A lot of reports I de-bug have errors that come back similiar to this:
Msg 8152, Level 16, State 14, Line 2
String or binary data would be truncated.
The reports are using Temp tables and I know something is not large enough to capture the info to the result set.
What I was hoping for is a generic SQL that I can interchange the table and string length into to look at the tables to determine my culprit faster.
I want to see what doctor name in my DoctorFacility table is over 60 VARCHAR characters.
SELECT df.listname where (characters > 60) ... something like that.