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!
-
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!
Recent content by JackTheDog
-
Aaggh! Desperate for help with trapping errors in a bulk insert!
any suggestions on how to capture 'converting varchar to numeric' 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 most often encounter in our...- JackTheDog
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
capturing varchar to numeric conversion error in a bulk insert
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...- JackTheDog
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
explicitly return a value from a called procedure
I would like to explicitly return a value from a called procedure without using the OUTPUT parameter. I can't seem to get this to work and get an error regarding converting to int. It's a string I want to pass & I've declared all of the pertinant variables as varchar. Do I have to use this...- JackTheDog
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
