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 |
Define table relations?
What is a column variable?
What is ado.net components?
What are the data access namespaces in .NET?
Is ADO.NET derived from COM? true /false
what is connection pooling ?
What are the various methods provided by the DataSet object to generate XML?
Define connection string?
What are the connected and disconnected modes in ado.net?
What are the three Objects of ADO.
What connected data?
Which namespaces are used for data access?
0 Answers SwanSoft Technologies,
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)