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 difference between executenonquery and executequery?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
What is the difference between connected environment and a disconnected environment?
How can you implement sub data grid in a master datagrid?
What is the difference between Response.Expires and Reponse.ExpiresAbsolute?
Which object is used to add relationship between two Datatables?
What is difference between connected and disconnected architecture in ado.net?
What is ado net stands for?
Explain the overview of ado.net architecture?
What do you mean by ‘batch updates’?
What is a data control clerk?
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.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)