Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error trapping at column level

Status
Not open for further replies.
GJP55

GJP55

Technical User
Joined
Feb 2, 2003
Messages
220
Location
GB
Is it possible to determine via an error message which column is causing an error when running a SQL statement?

I would like to trap errors that occur when inserting multiple field data into a table down to the field that is causing the error. I am specifically looking a data type errors (error 245).

Thanks
 
Status
Not open for further replies.

Similar threads

coorsman
  • Locked
  • Question Question
Column Data Type.
Replies
9
Views
1K
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question Question
How Do I Add Column to Middle of Table
Replies
4
Views
1K
BobSuruncle
BobSuruncle
leifoet
  • Locked
  • Question Question
Error in Select query
Replies
14
Views
1K
Andrzejek
Andrzejek
Virendra Yaduvanshi
  • Locked
  • Question Question
SSRS - Subscription page error
Replies
0
Views
552
Virendra Yaduvanshi
Virendra Yaduvanshi
Cpreston
  • Locked
  • Question Question
Update another column if text in another exists
Replies
4
Views
490
Cpreston
Cpreston

Part and Inventory Search

Sponsor

Back
Top