How to Handle the exceptions in Sqlsrver2000
- 3 Answers
- 6059 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 |
What is the meaning of executenonquery?
Define different execute methods of ADO.NET command object ?
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
feature of ADO.Net
What is the default timeout specified for "sqlcommand.commandtimeout" property?
Explain how to pass multiple tables in datasets simultaneously?
How do you update a dataset in ado.net?
How do you merge 2 datasets into the third dataset in a simple manner?
What are basic methods of dataadapter?
What is the difference between statement and preparedstatement interface?
How xml files and be read and write using dataset ?
How do you handle data concurrency in .NET ?
-
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)
