How to Handle the exceptions in Sqlsrver2000
- 3 Answers
- 6068 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 |
oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?
Which ado.net object is very fast in getting data from the database?
What is ole in excel?
How can we save all data from dataset?
When multiple users attempt to modify data at the same time Ex user 1 is updating record at same time user2 deleted record sucessfully.now user1 has press update button . how to handle concurrency
what purpose of Indexing creating? directly we can search the reqired row with the help of query?what is the use of indexing?
How we can provide data to ado.net?
Call a stored procedure from ado.net and pass parameter to it ?
7 Answers Keane India Ltd, TCS,
How you will set the datarelation between two columns?
Being fresher How would i answer to the question that what is your salary exception?
What are the methods of XML dataset object?
What is the namespace in which .NET has the data functionality classes?
-
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)
