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 |
C# Code for How to set readonly property to Id(database) value?
What is the difference between read and readline in c#?
What is ado net in c#?
Assembly Code. in Rejester AL. How do Contast Replece( or Change): Bit D3 With Bit D4 and Bit D2 With Bit D5 and Bit D1 With Bit D6 and Bit D0 With Bit D7 I am Not Know Very Well Write English.
Explain the difference between event and a delegate in c#?
Should I make my destructor virtual?
What is difference between virtual and override in c#?
What is the difference between Java and .NET garbage collectors?
What is yield return in c#?
What is thread life cycle in c#?
What is class method?
What is data type c#?