In a stored procedure 4 select stmts there.If error comes in
one select stmt will remaining normally executes?
Answer Posted / 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 |
Post New Answer View All Answers
Why we use delegates in c#?
What is alias in c#?
What is the purpose of private constructor in c#?
What is difference between const and static in c#?
Where do we set the min and max pool size for connection pooling?
What is Private Constructor? and it’s use? Can you create instance of a class which has Private Constructor?
How do you implement thread synchronization in c#?
For methods inside the interface why can’t you specify the accessibility modifier?
Could you explain the difference between func vs action vs predicate?
Why is xml called extensible?
Where is the keyword void used?
what will be the output of the given below coding. using System; public class Exercise { static void OddNumbers(int a) { if (a >= 1) { Console.Write("{0}, ", a); a -= 2; OddNumbers(a); } } public static int Main() { const int Number = 9; Console.WriteLine("Odd Numbers"); OddNumbers(Number); Console.WriteLine(); return 0; } }
What is difference between field and property in c#?
What is trim in c#?
What is the namespace for the thread class?