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 ado.net tutorial?

864


Is entity framework better than ado.net?

922


What is ado.net architecture?

875


What are all components of ADO.Net data provider?

1001


If a table contains 20000 records. In a page at each time 100 records to be displayed.

838


Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?

1011


Explain the namespaces in which .net has the data functionality class.

1007


What is bubbled event can you please explain?

962


What is sqldatasource?

875


What is Data view?

1003


How do you merge 2 datasets into the third dataset in a simple manner?

944


What are dcl commands?

954


What are the Features of a dataset

1178


What is data access pattern?

870


What is disconnected scenario in entity framework?

1048