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 are the usages of the command object in ado.net?
What is ole data type?
Which method do you invoke on the DataAdapter control to load your generated dataset with data?
5 Answers IBM, Veegyapan Impacts,
What does adodb stand for?
What is bubbled event?
Difference between ADO and ADO.Net
Does executenonquery return a value?
What does sqldatareader return?
What is ado.net object model?
Explain the two fundamental objects in ado.net?
What is the difference between ado.net and oledb?
What is difference between datatable and dataset?
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)