Jeff S
asked on
SQL 2005 Question
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.
For Example:
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.
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.
For Example:
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER