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
Why do we serialize data?
Explain the dataadapter class in ado.net?
What is openquery?
What is commandbuilder in ado.net?
What is ole used for?
What is data view and variable view?
Can you explain how to enable and disable connection pooling?
Describe briefly an ADO.NET Dataset ?
In how many ways we can retrieve table records count? How to find the count of records in a dataset?
What is ado.net explain with diagram?
What are the advantages using ado.net?
What are the different row versions available in table?
Which keyword is used to accept variable number of parameters?
What is difference between Dataview and Datatable?
What is the purpose of using adodb?