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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

capturing varchar to numeric conversion error in a bulk insert

Status
Not open for further replies.
JackTheDog

JackTheDog

Programmer
Feb 12, 2001
3
CA
any suggestions on how to capture this type of error (level 16, state 5). We've tested our code and if the error is a 'constraint' error (level 15, state 1) no problem. But if we try to insert varchar into a numeric field (which is the problem we encounter in our data) no go. The ONLY difference is the type of error. Are some errors trapable and some not????
 
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
How to convert varchar to time? 2
Replies
1
Views
1K
Chris Miller
Chris Miller
SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
929
SashaBuilder3
SashaBuilder3
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
652
Chris Miller
Chris Miller
leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
914
Andrzejek
Andrzejek
Cpreston
  • Locked
  • Question
How to add a Letter to datepart
Replies
5
Views
834
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top