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 delegates in c#?
How many digits is a 32 bit number?
What is use of list in c#?
What is delegates and events?
What is the difference between array and arraylist c#?
What is the difference b/w Arry.copy() and array.clone() method?
1. What is IIS. pl explain practically. 2. Difference b/w webserver and application server. pl explain practically.
Is c# still popular?
What is serialization in c#?
What is the c# equivalent of c++ catch (...), Which was a catch-all statement for any possible exception?
What is polymorphism and its types in c#?
What is data binding with example?