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 the difference between sqldatareader and sqldataadapter?
What are the different row versions available?
What does executenonquery () method return?
What is connected architecture in ado.net?
What is a datareader object?
How to retrieve the user id which is provided while windows authentication?
Differnce between Stored procedure and user defined functions?
17 Answers Microsoft, Symphony,
What is difference between datagridview and datagrid control in winforms?
What is ole used for?
can u tell me the why ADO does not support xml..
What is ado object model?
What two types of data providers does ADO.NET supply? What determines which one you should use?
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)