How to Handle the exceptions in Sqlsrver2000

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is full form of ado?

535


What does ado stand for in ado.net?

450


What is execute scalar in ado.net?

497


Which ado.net object is very fast in getting data from the database?

641


What is ole in vb?

504






What are the data providers used in ado.net

540


Explain what are acid properties?

536


How does ado.net work?

491


How will you fill the gridview by using datatable object at runtime?

548


Explain which name space is used to get assembly details?

522


How do you update database through dataset?

535


Explain the overview of ado.net architecture?

517


How to bind the controls(best practice) comboboxes to the data in the dataset?

540


What is ado circle?

659


What is read only and forward only in ado.net?

513