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 ado.net tutorial?
Is entity framework better than ado.net?
What is ado.net architecture?
What are all components of ADO.Net data provider?
If a table contains 20000 records. In a page at each time 100 records to be displayed.
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?
Explain the namespaces in which .net has the data functionality class.
What is bubbled event can you please explain?
What is sqldatasource?
What is Data view?
How do you merge 2 datasets into the third dataset in a simple manner?
What are dcl commands?
What are the Features of a dataset
What is data access pattern?
What is disconnected scenario in entity framework?