In a stored procedure 4 select stmts there.If error comes in
one select stmt will remaining normally executes?
Answers were Sorted based on User's Feedback
Answer / rajesh
Hi Guys
If any sql statements throws an error in the stored
procedure it just ignore the error and the control is passed
to the next statement,But in the case of function if any sql
statements throws any error it won't executes.
Ans:yes
Is This Answer Correct ? | 6 Yes | 3 No |
Answer / gopinath
Stored Procedure compiled Successfully.
when passing parameters to the stored procedure and executed
it shows the actual error.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / kanan
@rajesh
when you write answer , first check practically.
The Answer is NO
the reaming statements does not executes.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / venkatesh
@Kanan. Yes it ll execute. It is based on the sp.
For Example In that SP first two table have no error and the third table have error means ,
It ll give the First two tables results set then 3rd one ll show error,but it ll not show the 4th table results
Is This Answer Correct ? | 0 Yes | 0 No |
What are the properties of a string class?
Why do we need structs in c#?
What is a hash table in c#?
How do you restrict the type which can be used in custom generic?
Explain manifest & metadata.
What is private in c#?
What does console writeline do?
What is the purpose of a console table?
Is array thread safe c#?
How do I create a delegate/multicastdelegate?
What are properties in c#. Explain with an example?
What is the role of the datareader class in ado.net connections?