Common exceptions while executing sql queries

Question

I have read that catching the particular exception separately enhanced the performance so I just wanted to know what are the most common exception that might generate while executing any sql query

Community · Accepted Answer · 2017-05-23 12:26:49Z

2

It won't enhance performance, but exception handling provides a good way to control code flow.

The best article (the subject is too long for an SO answer) is "Error Handling in SQL 2005 and Later" by Erland Sommarskog. And shameless plug of my question here

However, if you mean in c# then there is really only SQLException.

As to what causes them, the main ones may be

constraint violation (fails CHECK, duplicate/UNIQUE, no parent/FK etc)
overflow and conversions (eg -1 to tinyint)

edited May 23, 2017 at 12:26

CommunityBot

11 silver badge

answered Oct 30, 2010 at 12:16

gbn

434k84 gold badges602 silver badges690 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Common exceptions while executing sql queries

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related