error checking for stored procedure

[prettitoni]

I'm using a stored procedure to insert records into an sql db through Visual Basic (very new to sql server programming). My question is, should I be performing error checking in my program code or in the stored procedure itself? (Error check such as make sure an entry is a number or string, proper length, etc...)

 

[hmckillop]

That sort of validation/error checking should be done at the application (VB side), as it doesnt make sense sending the data all the way to the database only for it to be UI error.
If you need to you can do business logic in the DB, but there are many different schools of thought were to apply business logic.


"I'm living so far beyond my income that we may almost be said to be living apart

 

[prettitoni]

Okie dokie. That's what I thought. Thank you.