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 is two way data binding android?
What is ole in vb?
What is the default provider in ado.net?
What is a string variable?
What is the significance of CommandBehavior.CloseConnection ?
Why do we serialize data?
What is the use of Dataview?
Define connection string?
What is the difference between linq and ado.net?
Explain how to call the sql commands asynchronously in ado.net version 2.0?
How can I retrieve two tables of data at a time by using data reader?
What is the difference between dataset and datatable?
What is difference between Dataview and Datatable?
What connected data?
What Is Difference Between Ado And Ado.net?