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
Explain the namespaces in which .net has the data functionality class.
Which object is used to add relationship between two Datatables?
What is ole db query?
What is the difference between typed and untyped dataset?
What is the usage of the dataset object in ado.net?
How do you update database through dataset?
Explain the difference in an abstract class and an interface?
How do you connect to sql server database without using sqlclient?
Data reader read and forward only, how is it possible to get 2 tables of data at a time?
Explain the advantages and disadvantages of using datalist?
What are the several execute methods of ado.net?
How will you fill the gridview by using datatable object at runtime?
What are the major difference between classic ADO and ADO.NET?
Explain why canot we use multiple inheritance and garbage collector paralelly in .net?
Explain the different row versions available in table?