How to Handle the exceptions in Sqlsrver2000
- 3 Answers
- 6540 Views
- SQL Star, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Define the data provider classes that is supported by ado.net?
What are the steps you will take to improve performance? Will you use dataset or datareader?
Explain how do you connect to sql server database without using sqlclient?
Explain the difference in record set and dataset?
What is an orm, and why would you use one instead of plain old ado.net?
What DataReader class do in ADO.NET ?
What are major difference between classic ADO and ADO.NET?
How to maintain the relation between two tables in ADO.NET?
0 Answers Petranics Solutions,
What are all the classes that are available in System.Data Namespace?
Which architecture does Datasets follow?
Which are the different IsolationLevels ?
What is ado.net tutorial?
-
Visual Basic (800) - C Sharp (3816)
- ASP.NET (3180)
- VB.NET (461)
- COM+ (79)
- ADO.NET (717)
- IIS (369)
- MTS (11)
- Crystal Reports (81)
- BizTalk (89)
- Dot Net (2435)
- Exchange Server (362)
- SharePoint (720)
- WCF (340)
- MS Office Microsoft (6963)
- LINQ Language-Integrated Query (317)
- WPF (371)
- TypeScript (144)
- Microsoft Related AllOther (311)
