Hi SQL Gurus!
Just wanted to know how I can trap errors in a stored procedure? Like if a value was entered more than once on a primary key field, how do I trap the error? To inform the application of the error I would just return an error number.
Thanx! in advance 8 )
Martin
Shit happens!!!