• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 218
  • Last Modified:

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.
0
Jeff S
Asked:
Jeff S
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
SELECT df.listname
from df
where len (df.listname ) > 60
0
 
Jeff SAuthor Commented:
THANKS!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now