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 difference between executenonquery and executequery?

704


What is Data view?

784


How do you merge 2 datasets into the third dataset in a simple manner?

772


Explain the advantage of ADO.Net?

746


What is data relation?

687


What is connected architecture in ado.net?

699


What is ado.net tutorial?

689


How to pass values into a datatable?

821


Explain the difference in record set and dataset?

699


What are basic methods of dataadapter?

714


What is the significance of CommandBehavior.CloseConnection ?

841


What is ado net stands for?

708


How can we add/remove row's in "datatable" object of "dataset"?

773


Which control of the BindingNavigator returns the current position within the data source?

931


Explain the architecture of ado.net?

807