How to Handle the exceptions in Sqlsrver2000
- 3 Answers
- 6083 Views
- SQL Star, I also Faced
- E-Mail Answers
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 what is datagrid with an example?
What is typed dataset ?
describe the dataset object in ado.net.
What is a datagridview?
What is the role of the dataset object in ado.net?
Explain the difference between an ado.net dataset and an ado recordset?
Which method in OLEDBAdapter is used to populate dataset with records?
What is the difference between sqlcommand and sqldataadapter?
What do you know about ADO.NET's objects and methods?
What are all the different methods under sqlcommand?
What is a column variable?
What are the benefits of using ado.net?
What is the use of data grid?
Describe briefly an ADO.NET Dataset ?
How would you connect to database using .NET?
