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 |
Explain the advantages and disadvantages of using datalist?
what is clustered index?why is it created?
What is serialization and de-serialization in .net?
What are the advantages of oledb compared with other classes?
Explain how to find the given query is optimised one or not?
What are the Different layers in ADO.Net?
Diff B/W DataSet vs DataTable
Difference between datareader and dataset?
26 Answers Microsoft, Noel Infotech, Satyam, Value Labs,
How to add a check box or a dropdown list to a column in a datagrid?
What are the data providers used in ado.net
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?
How to copy the contents from one table to another table and how to delete the source table 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)