Interested to Buy Any Domain ? << Click Here >> for more details...
How to Handle the exceptions in Sqlsrver2000
- 3 Answers
- 7303 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 |
Which object needs to be closed?
How can we load multiple tables in to dataset?
What are the advantages of ado.net?
How to pass multiple tables in datasets simultaneously?
What is the difference between Optimistic and Pessimistic locking?
What does executequery return?
What is the use of connection object in ado.net?
0 Answers TryTechnicals Pvt Ltd,
How will you fill the gridview by using datatable object at runtime?
Define ado.net?
What are all components of ADO.Net data provider?
What does ADO.NET consists of ?
How to Handle the exceptions in Sqlsrver2000
-
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)
