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

What are the different ado.net namespaces?

0 Answers  


What are the data providers in ADO.NET framework?

0 Answers  


What is sqldatareader in ado.net?

0 Answers  


Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?

0 Answers  


What is the meaning of object pooling?

0 Answers  


what purpose of Indexing creating? directly we can search the reqired row with the help of query?what is the use of indexing?

3 Answers  


What is the significance of CommandBehavior.CloseConnection ?

0 Answers   NA,


How can we load multiple tables in a dataset?

0 Answers  


Diff. b/w DataReader and DataSet?

8 Answers   Avon, Value Labs,


What are the parameters that control most of connection pooling behaviors?

0 Answers  


What is the difference between a datareader and a dataset?

0 Answers  


What are the Features and disadvantages of dataset

0 Answers   Microsoft,


Categories