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
What are the ado.net components?
What are the different methods by which we can populate a dataset?
What is the difference between ado.net and oledb?
What is ado recordset?
How can we load multiple tables in a dataset?
What is a string variable?
Define table relations?
Describe briefly an ADO.NET Dataset ?
What is the difference between Optimistic and Pessimistic locking?
What are the benefits of using of ADO.NET in .NET 4.0?
Define data access layer?
Explain sqlconnection object?
Explain the difference between sqlcommand object and command behavior object?
Some important instruction regarding ADO.NET connection string ?
What are the several execute methods of ado.net?