How to Handle the exceptions in Sqlsrver2000

Question Posted / sharifuddin

3 Answers
6096 Views
SQL Star, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to Handle the exceptions in Sqlsrver2000..

Answer / deepesh jain

@@Error

Is This Answer Correct ?

7 Yes

1 No

How to Handle the exceptions in Sqlsrver2000..

Answer / sisira

you can handle
RAISEERROR

Is This Answer Correct ?

4 Yes

1 No

How to Handle the exceptions in Sqlsrver2000..

Answer / bolisettyvaas

In SQL Server 2000 there is no powerful error handling like
.Net. But you can use one global variable @@ERROR. So after
every dml statement, you can retrieve this variable value
and verify if the value is not equal to 0 then it means some
error occured. otherwise no errors in the last executed
statement.

Is This Answer Correct ?

3 Yes

0 No

Post New Answer

More ADO.NET Interview Questions

What are the steps you will take to improve performance? Will you use dataset or datareader?

0 Answers

Diff. b/w DataReader and DataSet?

8 Answers Avon, Value Labs,

what is type dataset?

3 Answers

Can you edit data in the Repeater control?