Interested to Buy Any Domain ? << Click Here >> for more details...
How to Handle the exceptions in Sqlsrver2000
- 3 Answers
- 7151 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
Which database is the ado.net?
What are the different methods by which we can populate a dataset?
What is sqlconnection and sqlcommand?
Describe the command object and its method.
Explain the dataadapter class in ado.net?
What is executenonquery ado.net?
Explain the role of data provider in ado.net?
How can we check that some changes have been made to dataset since it was loaded?
What is the maximum pool size in ado.net connection string?
Is it possible to edit data in Repeater control?
Is ado.net dead?
What do you know about ADO.NET's objects and methods?
How can I retrieve two tables of data at a time by using data reader?
Describe datareader object of ado.net with example.
Define the data provider classes that is supported by ado.net?
