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 |
how Sequence to connect and retrieve data from database using dataset?
How many major types of connection objects in ADO.NET?
What are the core objects of ADO.NET?
What provider ado.net use by default? Explain the role of data provider in ado.net?
What is ODP.NET ?
What is the default view of Data Grid?
Why do we serialize data?
What is a datagrid?
What is the difference between the clone() and copy() methods of the dataset class?
What is difference between connected and disconnected architecture in ado.net?
What is the difference between data reader and data adapter?
What is difference between dataset and datatable?
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)