Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Why do we serialize data?

948


Explain the dataadapter class in ado.net?

1211


What is openquery?

988


What is commandbuilder in ado.net?

1031


What is ole used for?

943


What is data view and variable view?

923


Can you explain how to enable and disable connection pooling?

965


Describe briefly an ADO.NET Dataset ?

1089


In how many ways we can retrieve table records count? How to find the count of records in a dataset?

1011


What is ado.net explain with diagram?

960


What are the advantages using ado.net?

1039


What are the different row versions available in table?

979


Which keyword is used to accept variable number of parameters?

1128


What is difference between Dataview and Datatable?

1072


What is the purpose of using adodb?

962