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

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

1154


Which object is used to add relationship between two Datatables?

1093


What is ole db query?

1024


What is the difference between typed and untyped dataset?

1162


What is the usage of the dataset object in ado.net?

1005


How do you update database through dataset?

1025


Explain the difference in an abstract class and an interface?

973


How do you connect to sql server database without using sqlclient?

1169


Data reader read and forward only, how is it possible to get 2 tables of data at a time?

961


Explain the advantages and disadvantages of using datalist?

1112


What are the several execute methods of ado.net?

974


How will you fill the gridview by using datatable object at runtime?

1108


What are the major difference between classic ADO and ADO.NET?

1054


Explain why canot we use multiple inheritance and garbage collector paralelly in .net?

1065


Explain the different row versions available in table?

1118