How to Handle the exceptions in Sqlsrver2000
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 ado in agriculture?
What is dataset object? Explain the various objects in dataset.
What happens when u try to update data in a dataset in .NET while the record is already deleted in SQL SERVER as backend?
What are the main differences between classic ado and ado.net?
how to create a quiz software using 4 options to answer and how to check with answers in the database and award marks....
I want to ask u that if i add radio button in ado.net form,and how radion button data insert in SQL2005 Database...
What are the different ado.net namespaces?
What are the benefits of using ado.net?
What are the ado.net objects?
What is commandbuilder in ado.net?
What is Serialization in .NET? what are the types of Serialization?
What are the important features of ado.net 2.0?
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)