When we are running the Application, if any errors occur in
the Stored Procedure then how will the server identify the
errors?

Answers were Sorted based on User's Feedback



When we are running the Application, if any errors occur in the Stored Procedure then how will the..

Answer / vinforum

Using SqlException handlers.

Is This Answer Correct ?    12 Yes 1 No

When we are running the Application, if any errors occur in the Stored Procedure then how will the..

Answer / sinthu vijay kumar

i think by using sqlexception handler

Is This Answer Correct ?    2 Yes 0 No

When we are running the Application, if any errors occur in the Stored Procedure then how will the..

Answer / revathi

SqlException handler

Is This Answer Correct ?    2 Yes 0 No

When we are running the Application, if any errors occur in the Stored Procedure then how will the..

Answer / ...

RaiseError

Is This Answer Correct ?    1 Yes 1 No

When we are running the Application, if any errors occur in the Stored Procedure then how will the..

Answer / sivakumar m

if @@ERROR>0 then
begin
'Error Block
end

Is This Answer Correct ?    3 Yes 4 No

Post New Answer

More ADO.NET Interview Questions

Give an example of a .net application which connects to microsoft access database using ado.net classes.

0 Answers  


What providers does ado.net uses internally ?

3 Answers   Digital GlobalSoft,


Do we use stored procedure in ADO.Net?

0 Answers  


What is Dataset Object?

0 Answers  


What are the key events of sqlconnection class?

0 Answers  






Explain how to bind the controls(best practice) comboboxes to the data in the dataset?

0 Answers  


What is ado.net object model?

0 Answers  


How many commands does the oledbcommand takes?what are they?

2 Answers  


What does connection string consists of ?

4 Answers   Digital GlobalSoft,


What is the difference between sqlcommand and sqldataadapter?

0 Answers  


Define data access layer?

0 Answers  


Which object needs to be closed?

0 Answers  


Categories