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 difference between executenonquery and executequery?
What is Data view?
How do you merge 2 datasets into the third dataset in a simple manner?
Explain the advantage of ADO.Net?
What is data relation?
What is connected architecture in ado.net?
What is ado.net tutorial?
How to pass values into a datatable?
Explain the difference in record set and dataset?
What are basic methods of dataadapter?
What is the significance of CommandBehavior.CloseConnection ?
What is ado net stands for?
How can we add/remove row's in "datatable" object of "dataset"?
Which control of the BindingNavigator returns the current position within the data source?
Explain the architecture of ado.net?