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 are the ado.net components?

777


What are the different methods by which we can populate a dataset?

963


What is the difference between ado.net and oledb?

713


What is ado recordset?

700


How can we load multiple tables in a dataset?

800


What is a string variable?

675


Define table relations?

754


Describe briefly an ADO.NET Dataset ?

767


What is the difference between Optimistic and Pessimistic locking?

763


What are the benefits of using of ADO.NET in .NET 4.0?

754


Define data access layer?

731


Explain sqlconnection object?

777


Explain the difference between sqlcommand object and command behavior object?

769


Some important instruction regarding ADO.NET connection string ?

766


What are the several execute methods of ado.net?

700