How to Handle the exceptions in Sqlsrver2000

Question Posted / sharifuddin

3 Answers
7300 Views
SQL Star, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to Handle the exceptions in Sqlsrver2000..

Answer / deepesh jain

@@Error

Is This Answer Correct ?

7 Yes

1 No

How to Handle the exceptions in Sqlsrver2000..

Answer / sisira

you can handle
RAISEERROR

Is This Answer Correct ?

4 Yes

1 No

How to Handle the exceptions in Sqlsrver2000..

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

Post New Answer

More ADO.NET Interview Questions

What is a string variable?

0 Answers

What does executequery return?

0 Answers

What is the default provider in ado.net?

0 Answers

Is bulk insert faster than insert?

0 Answers

What does adodb stand for?

0 Answers

i have two textboxes one for user name and another for password . i have a table name compare(which contains name,passwod etc.,)my doubt is how compare username textbox with name column and how compare password textbox with passwod column. i want the code

9 Answers Wipro,

Explain what is datagrid with an example?

0 Answers C DAC, CDAC,

How to get the new oledb connection of oracle in database programming?

1 Answers

What are datareaders?

0 Answers

Being fresher How would i answer to the question that what is your salary exception?

4 Answers

How does ado.net work?

0 Answers

What are the advantages of using datalist?

0 Answers

For more ADO.NET Interview Questions Click Here