How to Handle the exceptions in Sqlsrver2000

Question Posted / sharifuddin

3 Answers
7130 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

If a table contains 20000 records . In a page at each time 100 records to be displayed. What are the steps u will take to improve performance? will you use dataset or datareader?

7 Answers

Define atomicity?

0 Answers

what is the syntax code for oldb to connect oracle?

2 Answers

make a login control??

1 Answers

Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

0 Answers

What is difference between ado and other data object?

0 Answers

what is bubbled event can u pls explain