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

What is two way data binding android?

986


What is ole in vb?

901


What is the default provider in ado.net?

963


What is a string variable?

916


What is the significance of CommandBehavior.CloseConnection ?

1165


Why do we serialize data?

942


What is the use of Dataview?

1128


Define connection string?

1066


What is the difference between linq and ado.net?

997


Explain how to call the sql commands asynchronously in ado.net version 2.0?

927


How can I retrieve two tables of data at a time by using data reader?

1014


What is the difference between dataset and datatable?

1002


What is difference between Dataview and Datatable?

1064


What connected data?

957


What Is Difference Between Ado And Ado.net?

1031